Hi
is there a stored procedure which allows me to query if there is an existing backup device? or which gives me a listing of existing backup devices?
Thanks!SP_HELPDEVICE and in SQL 2K this is used for backward compatibility with earlier versions of SQL Server.
Refer to books online for more information.|||Thanx Satya. Appreciate.
Showing posts with label procedure. Show all posts
Showing posts with label procedure. Show all posts
Tuesday, March 20, 2012
backup db
I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable devic
e,
> but I don't know exactly when the backup is finished. can I add something
in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable devic
e,
> but I don't know exactly when the backup is finished. can I add something
in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>
backup db
I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable device,
> but I don't know exactly when the backup is finished. can I add something in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable device,
> but I don't know exactly when the backup is finished. can I add something in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>
Sunday, March 11, 2012
backup database database remotely
i have a stored procedure that backups database on server A which i execute this SP from server B in a scheduled job. when i run this job it gives me an error:
Executed as user: domain\user_name. Could not relay results of procedure 'usp_BackupDBOnServerA' from remote server 'ServerB'. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 7312). The step failed.
i searched MS KB, everywhere but could not find the solution or even explanation why this happenning.
both sql servers are 2000 and they are linked.It seems like an account permissions issue. I would look over the SP and make sure that the account which SQLServer service, SQLAgent service, and the scheduled job has access to the SP as well as the network share which the backup is being written too.
Does the whole backup fail or does it just not return what happened (the result or output)?|||actually there's no issue with account's permissions. and to asnwer your question the job itself fails.
but i just figured out how to solve the issue: i increased the Remote query timeout in the Server properties.
thanks for the help anyway.|||Great! Thanks for posting the answer, it helps with other people who might run into the same problem.
Executed as user: domain\user_name. Could not relay results of procedure 'usp_BackupDBOnServerA' from remote server 'ServerB'. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 7312). The step failed.
i searched MS KB, everywhere but could not find the solution or even explanation why this happenning.
both sql servers are 2000 and they are linked.It seems like an account permissions issue. I would look over the SP and make sure that the account which SQLServer service, SQLAgent service, and the scheduled job has access to the SP as well as the network share which the backup is being written too.
Does the whole backup fail or does it just not return what happened (the result or output)?|||actually there's no issue with account's permissions. and to asnwer your question the job itself fails.
but i just figured out how to solve the issue: i increased the Remote query timeout in the Server properties.
thanks for the help anyway.|||Great! Thanks for posting the answer, it helps with other people who might run into the same problem.
Backup database aborts job in the agent, but not when in a query window
Does anyone know why a backup database statement aborts a job in a stored procedure so that you can't handle the error with @.@.error, but when you run the same stored procedure in a query window the error handling does get run?
The snippet of code looks like this:
SET XACT_ABORT OFF
SET ANSI_NULLS OFF
set ansi_warnings off
set arithabort on
declare @.backup_status int
declare @.cmd varchar(1024)
SET NOCOUNT ON
print 'Options value: ' + convert(varchar, @.@.options)
set @.backup_status = 0
if (@.backup_mode = 'F')
begin
BACKUP DATABASE
@.DB TO DISK = @.BackupFile
with
NAME = @.Name,
DESCRIPTION = @.Description,
MEDIANAME = @.MediaName,
MEDIADESCRIPTION = @.Description,
STATS = 10,
init, nounload, noskip
if @.@.error != 0
begin
set @.backup_status = 1
print '**************** Backup of ' + @.DB + ' Failed'
end end
When this is run in a query window, the print statement at the bottom does get executed, but when run as a step in a sql agent job it does not.
Thanks.
As an additional comment, this doesn't seem to happen on my SQL 2000 server, just the SQL 2005 sp1 server.Backup Database
HI
i have created job which executes following Store Procedure, my Qs is after 1-day has passed shldnt it overwrite , i mean i have 1-GB Database my job runs for 3-times a day so end of day i have 3-GB so wen time goes past 12.00 am shldnt it becomes 1-GB again
Alter Procedure sp_DBBackup as
BACKUP DATABASE [XYZ] TO
DISK = N'D:\Office Purpose\Database\Backups\XYZ\Backup-Method (Append-Expiry)\XYZ_Complete_Append.Bak'
WITH NOINIT ,
NOUNLOAD ,
RETAINDAYS = 1,
NAME = N'XYZ backup',
NOSKIP ,
STATS = 10,
NOFORMAT
No....you are using NOINIT so you are appending backups to the device. You would use RETAINDAYS to throw up an error message if you try to do an INIT and you do a NOSKIP meaning that it will check to see if you have any backups that aren't yet expired. If there are backups not yet expired, you get an error. That's about all RETAINDAYS does - it won't maintain your history for you - it just keeps you from overwriting.
-Sue
Thursday, March 8, 2012
Backup check
Hello,
I want to create a stored procedure to
check if backups ended successfully at remote databases.
Which query can i run?
Many Thanks in Advance,
Galit.Gal
Assuming you are running your backups as jobs. The
information you need should be on sysjobhistory on the
msdb database. You can write a stored procedure to get the
information from there.
Regards
John
I want to create a stored procedure to
check if backups ended successfully at remote databases.
Which query can i run?
Many Thanks in Advance,
Galit.Gal
Assuming you are running your backups as jobs. The
information you need should be on sysjobhistory on the
msdb database. You can write a stored procedure to get the
information from there.
Regards
John
Backup and zip the Transaction log file
Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name
the current date DD/MM/yyyy as the text file name
exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')
Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...hey... its URGENT.... pls can anybody help me on this...... :(
Backup and zip the Transaction log file
Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name
the current date DD/MM/yyyy as the text file name
exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')
Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...As you have posted a question in the articles section it is being moved to SQL Server Forum.
MODERATOR.
Wednesday, March 7, 2012
Backup and Restore of the Cluster
Hello
I want backup my SQL Server Cluster (two nodes) and to restore it on other
two nodes on another site.
I need to know that procedure to test my DRP. I know that the best would to
have a geocluster but for now (budget limitations) I just want to be able to
restore the cluster.
I would like your help to point me documentation about how to do this
procedure or if someone has any experience about I would be glad to know.
Thanks in advance.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
Carlos hi,
You will find plenty of information in BOL. Search by planning for disaster
recovery
Also, read the following article and it's links
http://support.microsoft.com/default...b;en-us;307775
HTH
Andreas
"Carlos Eduardo Selonke de Souza" wrote:
> Hello
> I want backup my SQL Server Cluster (two nodes) and to restore it on other
> two nodes on another site.
> I need to know that procedure to test my DRP. I know that the best would to
> have a geocluster but for now (budget limitations) I just want to be able to
> restore the cluster.
> I would like your help to point me documentation about how to do this
> procedure or if someone has any experience about I would be glad to know.
> Thanks in advance.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org
|||Hello Andreas
Thanks for you repply but Im looking for information about backup and
restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
Server.
I am most interessed in how to restore the master and msdb database on the
new virtual server, since the user databases is pretty easy.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
"Andreas Mavrogenis" wrote:
[vbcol=seagreen]
> Carlos hi,
> You will find plenty of information in BOL. Search by planning for disaster
> recovery
> Also, read the following article and it's links
> http://support.microsoft.com/default...b;en-us;307775
> HTH
> Andreas
> "Carlos Eduardo Selonke de Souza" wrote:
|||Hi Carlos,
If you don't have a different instance name, the things that you have to do
are to create your logins to the new server with a DTS Package and after
restoring all your databases, except master, msdb, execute the
sp_change_users_login (Ref. BOL) to assign the roles. Then you will be ready
to check and follow the article below.
http://msdn.microsoft.com/library/de...kprst_4g4w.asp
Please, use them first in a test environment if applicable.
HTH
Andreas
"Carlos Eduardo Selonke de Souza" wrote:
[vbcol=seagreen]
> Hello Andreas
> Thanks for you repply but Im looking for information about backup and
> restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
> Server.
> I am most interessed in how to restore the master and msdb database on the
> new virtual server, since the user databases is pretty easy.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org
>
> "Andreas Mavrogenis" wrote:
I want backup my SQL Server Cluster (two nodes) and to restore it on other
two nodes on another site.
I need to know that procedure to test my DRP. I know that the best would to
have a geocluster but for now (budget limitations) I just want to be able to
restore the cluster.
I would like your help to point me documentation about how to do this
procedure or if someone has any experience about I would be glad to know.
Thanks in advance.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
Carlos hi,
You will find plenty of information in BOL. Search by planning for disaster
recovery
Also, read the following article and it's links
http://support.microsoft.com/default...b;en-us;307775
HTH
Andreas
"Carlos Eduardo Selonke de Souza" wrote:
> Hello
> I want backup my SQL Server Cluster (two nodes) and to restore it on other
> two nodes on another site.
> I need to know that procedure to test my DRP. I know that the best would to
> have a geocluster but for now (budget limitations) I just want to be able to
> restore the cluster.
> I would like your help to point me documentation about how to do this
> procedure or if someone has any experience about I would be glad to know.
> Thanks in advance.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org
|||Hello Andreas
Thanks for you repply but Im looking for information about backup and
restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
Server.
I am most interessed in how to restore the master and msdb database on the
new virtual server, since the user databases is pretty easy.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
"Andreas Mavrogenis" wrote:
[vbcol=seagreen]
> Carlos hi,
> You will find plenty of information in BOL. Search by planning for disaster
> recovery
> Also, read the following article and it's links
> http://support.microsoft.com/default...b;en-us;307775
> HTH
> Andreas
> "Carlos Eduardo Selonke de Souza" wrote:
|||Hi Carlos,
If you don't have a different instance name, the things that you have to do
are to create your logins to the new server with a DTS Package and after
restoring all your databases, except master, msdb, execute the
sp_change_users_login (Ref. BOL) to assign the roles. Then you will be ready
to check and follow the article below.
http://msdn.microsoft.com/library/de...kprst_4g4w.asp
Please, use them first in a test environment if applicable.
HTH
Andreas
"Carlos Eduardo Selonke de Souza" wrote:
[vbcol=seagreen]
> Hello Andreas
> Thanks for you repply but Im looking for information about backup and
> restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
> Server.
> I am most interessed in how to restore the master and msdb database on the
> new virtual server, since the user databases is pretty easy.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org
>
> "Andreas Mavrogenis" wrote:
Sunday, February 19, 2012
Backup / Restore select SP
Hi,
Any suggestions on Backup / Restore of a select Table /
Stored Procedure etc?
RaoFor a non-data carrying object (everything except table), generate script.
To do this from code, use the DMO API.
For a table, (I assume you also want data), you can generate script and also
use BCP, DTS or some similar method for the data.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rao" <chtvrao@.valona.com> wrote in message
news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
> Hi,
> Any suggestions on Backup / Restore of a select Table /
> Stored Procedure etc?
> Rao|||Thanks for the suggestions. While these give me clues
related to the topic, my requirement is somewaht specific
and it is like this.
We are in consulting and while we want to send updates to
clients, we do not want to send the source code. So to
send an encrypted Stored Procedure(s) only, I am looking
at a way.
Any more suggestions Please?
Rao
>--Original Message--
>For a non-data carrying object (everything except table),
generate script.
>To do this from code, use the DMO API.
>For a table, (I assume you also want data), you can
generate script and also
>use BCP, DTS or some similar method for the data.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Rao" <chtvrao@.valona.com> wrote in message
>news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
>> Hi,
>> Any suggestions on Backup / Restore of a select Table /
>> Stored Procedure etc?
>> Rao
>
>.
>|||> We are in consulting and while we want to send updates to
> clients, we do not want to send the source code. So to
> send an encrypted Stored Procedure(s) only, I am looking
> at a way.
There's really no way to send an encrypted stored procedure. The closes you
probably can come is to have your customers execute an exe file where the
CREATE statements are inside the EXE file. I.e., having the EXE file be the
"scrambler". Unfortunately, Profiler will show these statements, but on the
other side there are tools out there that crack this encryption, so if your
customer really wants to...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rao" <chtvrao@.valona.com> wrote in message
news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
> Thanks for the suggestions. While these give me clues
> related to the topic, my requirement is somewaht specific
> and it is like this.
> We are in consulting and while we want to send updates to
> clients, we do not want to send the source code. So to
> send an encrypted Stored Procedure(s) only, I am looking
> at a way.
> Any more suggestions Please?
> Rao
> >--Original Message--
> >For a non-data carrying object (everything except table),
> generate script.
> >To do this from code, use the DMO API.
> >
> >For a table, (I assume you also want data), you can
> generate script and also
> >use BCP, DTS or some similar method for the data.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Rao" <chtvrao@.valona.com> wrote in message
> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
> >> Hi,
> >> Any suggestions on Backup / Restore of a select Table /
> >> Stored Procedure etc?
> >>
> >> Rao
> >
> >
> >.
> >|||Hi Tibor,
Thanks for the details. I know the existence of these
tools to decrypt the SPs. Anyway we have to live with it.
Could you please throw me some light on how others in the
consulting field offer their work to clients and still
safeguard their IP(Intelectual Proprty)?
Rao
>--Original Message--
>> We are in consulting and while we want to send updates
to
>> clients, we do not want to send the source code. So to
>> send an encrypted Stored Procedure(s) only, I am looking
>> at a way.
>There's really no way to send an encrypted stored
procedure. The closes you
>probably can come is to have your customers execute an
exe file where the
>CREATE statements are inside the EXE file. I.e., having
the EXE file be the
>"scrambler". Unfortunately, Profiler will show these
statements, but on the
>other side there are tools out there that crack this
encryption, so if your
>customer really wants to...
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Rao" <chtvrao@.valona.com> wrote in message
>news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
>> Thanks for the suggestions. While these give me clues
>> related to the topic, my requirement is somewaht
specific
>> and it is like this.
>> We are in consulting and while we want to send updates
to
>> clients, we do not want to send the source code. So to
>> send an encrypted Stored Procedure(s) only, I am looking
>> at a way.
>> Any more suggestions Please?
>> Rao
>> >--Original Message--
>> >For a non-data carrying object (everything except
table),
>> generate script.
>> >To do this from code, use the DMO API.
>> >
>> >For a table, (I assume you also want data), you can
>> generate script and also
>> >use BCP, DTS or some similar method for the data.
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Rao" <chtvrao@.valona.com> wrote in message
>> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
>> >> Hi,
>> >> Any suggestions on Backup / Restore of a select
Table /
>> >> Stored Procedure etc?
>> >>
>> >> Rao
>> >
>> >
>> >.
>> >
>
>.
>|||> Could you please throw me some light on how others in the
> consulting field offer their work to clients and still
> safeguard their IP(Intelectual Proprty)?
You should start a new thread on that, with proper subject. That would
probably be the best way to poll. Also, programming is probably a better
group for that. I've used encryption just to "make it harder". But even .exe
file can be "decompiled", so technical solutions only takes you so far. The
general recommendation is to do it by legal measures.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rao" <chtvrao@.valona.com> wrote in message
news:07bf01c3a506$ee94ecb0$a401280a@.phx.gbl...
> Hi Tibor,
> Thanks for the details. I know the existence of these
> tools to decrypt the SPs. Anyway we have to live with it.
> Could you please throw me some light on how others in the
> consulting field offer their work to clients and still
> safeguard their IP(Intelectual Proprty)?
> Rao
> >--Original Message--
> >> We are in consulting and while we want to send updates
> to
> >> clients, we do not want to send the source code. So to
> >> send an encrypted Stored Procedure(s) only, I am looking
> >> at a way.
> >
> >There's really no way to send an encrypted stored
> procedure. The closes you
> >probably can come is to have your customers execute an
> exe file where the
> >CREATE statements are inside the EXE file. I.e., having
> the EXE file be the
> >"scrambler". Unfortunately, Profiler will show these
> statements, but on the
> >other side there are tools out there that crack this
> encryption, so if your
> >customer really wants to...
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Rao" <chtvrao@.valona.com> wrote in message
> >news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
> >> Thanks for the suggestions. While these give me clues
> >> related to the topic, my requirement is somewaht
> specific
> >> and it is like this.
> >>
> >> We are in consulting and while we want to send updates
> to
> >> clients, we do not want to send the source code. So to
> >> send an encrypted Stored Procedure(s) only, I am looking
> >> at a way.
> >>
> >> Any more suggestions Please?
> >>
> >> Rao
> >>
> >> >--Original Message--
> >> >For a non-data carrying object (everything except
> table),
> >> generate script.
> >> >To do this from code, use the DMO API.
> >> >
> >> >For a table, (I assume you also want data), you can
> >> generate script and also
> >> >use BCP, DTS or some similar method for the data.
> >> >
> >> >--
> >> >Tibor Karaszi, SQL Server MVP
> >> >Archive at:
> >> >http://groups.google.com/groups?
> >> oi=djq&as_ugroup=microsoft.public.sqlserver
> >> >
> >> >
> >> >"Rao" <chtvrao@.valona.com> wrote in message
> >> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
> >> >> Hi,
> >> >> Any suggestions on Backup / Restore of a select
> Table /
> >> >> Stored Procedure etc?
> >> >>
> >> >> Rao
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Hi Tibor,
Thanks for all the info. Let me see what I can do.
Rao
>--Original Message--
>> Could you please throw me some light on how others in
the
>> consulting field offer their work to clients and still
>> safeguard their IP(Intelectual Proprty)?
>You should start a new thread on that, with proper
subject. That would
>probably be the best way to poll. Also, programming is
probably a better
>group for that. I've used encryption just to "make it
harder". But even .exe
>file can be "decompiled", so technical solutions only
takes you so far. The
>general recommendation is to do it by legal measures.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Rao" <chtvrao@.valona.com> wrote in message
>news:07bf01c3a506$ee94ecb0$a401280a@.phx.gbl...
>> Hi Tibor,
>> Thanks for the details. I know the existence of these
>> tools to decrypt the SPs. Anyway we have to live with
it.
>> Could you please throw me some light on how others in
the
>> consulting field offer their work to clients and still
>> safeguard their IP(Intelectual Proprty)?
>> Rao
>> >--Original Message--
>> >> We are in consulting and while we want to send
updates
>> to
>> >> clients, we do not want to send the source code. So
to
>> >> send an encrypted Stored Procedure(s) only, I am
looking
>> >> at a way.
>> >
>> >There's really no way to send an encrypted stored
>> procedure. The closes you
>> >probably can come is to have your customers execute an
>> exe file where the
>> >CREATE statements are inside the EXE file. I.e., having
>> the EXE file be the
>> >"scrambler". Unfortunately, Profiler will show these
>> statements, but on the
>> >other side there are tools out there that crack this
>> encryption, so if your
>> >customer really wants to...
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Rao" <chtvrao@.valona.com> wrote in message
>> >news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
>> >> Thanks for the suggestions. While these give me clues
>> >> related to the topic, my requirement is somewaht
>> specific
>> >> and it is like this.
>> >>
>> >> We are in consulting and while we want to send
updates
>> to
>> >> clients, we do not want to send the source code. So
to
>> >> send an encrypted Stored Procedure(s) only, I am
looking
>> >> at a way.
>> >>
>> >> Any more suggestions Please?
>> >>
>> >> Rao
>> >>
>> >> >--Original Message--
>> >> >For a non-data carrying object (everything except
>> table),
>> >> generate script.
>> >> >To do this from code, use the DMO API.
>> >> >
>> >> >For a table, (I assume you also want data), you can
>> >> generate script and also
>> >> >use BCP, DTS or some similar method for the data.
>> >> >
>> >> >--
>> >> >Tibor Karaszi, SQL Server MVP
>> >> >Archive at:
>> >> >http://groups.google.com/groups?
>> >> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >> >
>> >> >
>> >> >"Rao" <chtvrao@.valona.com> wrote in message
>> >> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
>> >> >> Hi,
>> >> >> Any suggestions on Backup / Restore of a select
>> Table /
>> >> >> Stored Procedure etc?
>> >> >>
>> >> >> Rao
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>
Any suggestions on Backup / Restore of a select Table /
Stored Procedure etc?
RaoFor a non-data carrying object (everything except table), generate script.
To do this from code, use the DMO API.
For a table, (I assume you also want data), you can generate script and also
use BCP, DTS or some similar method for the data.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rao" <chtvrao@.valona.com> wrote in message
news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
> Hi,
> Any suggestions on Backup / Restore of a select Table /
> Stored Procedure etc?
> Rao|||Thanks for the suggestions. While these give me clues
related to the topic, my requirement is somewaht specific
and it is like this.
We are in consulting and while we want to send updates to
clients, we do not want to send the source code. So to
send an encrypted Stored Procedure(s) only, I am looking
at a way.
Any more suggestions Please?
Rao
>--Original Message--
>For a non-data carrying object (everything except table),
generate script.
>To do this from code, use the DMO API.
>For a table, (I assume you also want data), you can
generate script and also
>use BCP, DTS or some similar method for the data.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Rao" <chtvrao@.valona.com> wrote in message
>news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
>> Hi,
>> Any suggestions on Backup / Restore of a select Table /
>> Stored Procedure etc?
>> Rao
>
>.
>|||> We are in consulting and while we want to send updates to
> clients, we do not want to send the source code. So to
> send an encrypted Stored Procedure(s) only, I am looking
> at a way.
There's really no way to send an encrypted stored procedure. The closes you
probably can come is to have your customers execute an exe file where the
CREATE statements are inside the EXE file. I.e., having the EXE file be the
"scrambler". Unfortunately, Profiler will show these statements, but on the
other side there are tools out there that crack this encryption, so if your
customer really wants to...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rao" <chtvrao@.valona.com> wrote in message
news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
> Thanks for the suggestions. While these give me clues
> related to the topic, my requirement is somewaht specific
> and it is like this.
> We are in consulting and while we want to send updates to
> clients, we do not want to send the source code. So to
> send an encrypted Stored Procedure(s) only, I am looking
> at a way.
> Any more suggestions Please?
> Rao
> >--Original Message--
> >For a non-data carrying object (everything except table),
> generate script.
> >To do this from code, use the DMO API.
> >
> >For a table, (I assume you also want data), you can
> generate script and also
> >use BCP, DTS or some similar method for the data.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Rao" <chtvrao@.valona.com> wrote in message
> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
> >> Hi,
> >> Any suggestions on Backup / Restore of a select Table /
> >> Stored Procedure etc?
> >>
> >> Rao
> >
> >
> >.
> >|||Hi Tibor,
Thanks for the details. I know the existence of these
tools to decrypt the SPs. Anyway we have to live with it.
Could you please throw me some light on how others in the
consulting field offer their work to clients and still
safeguard their IP(Intelectual Proprty)?
Rao
>--Original Message--
>> We are in consulting and while we want to send updates
to
>> clients, we do not want to send the source code. So to
>> send an encrypted Stored Procedure(s) only, I am looking
>> at a way.
>There's really no way to send an encrypted stored
procedure. The closes you
>probably can come is to have your customers execute an
exe file where the
>CREATE statements are inside the EXE file. I.e., having
the EXE file be the
>"scrambler". Unfortunately, Profiler will show these
statements, but on the
>other side there are tools out there that crack this
encryption, so if your
>customer really wants to...
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Rao" <chtvrao@.valona.com> wrote in message
>news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
>> Thanks for the suggestions. While these give me clues
>> related to the topic, my requirement is somewaht
specific
>> and it is like this.
>> We are in consulting and while we want to send updates
to
>> clients, we do not want to send the source code. So to
>> send an encrypted Stored Procedure(s) only, I am looking
>> at a way.
>> Any more suggestions Please?
>> Rao
>> >--Original Message--
>> >For a non-data carrying object (everything except
table),
>> generate script.
>> >To do this from code, use the DMO API.
>> >
>> >For a table, (I assume you also want data), you can
>> generate script and also
>> >use BCP, DTS or some similar method for the data.
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Rao" <chtvrao@.valona.com> wrote in message
>> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
>> >> Hi,
>> >> Any suggestions on Backup / Restore of a select
Table /
>> >> Stored Procedure etc?
>> >>
>> >> Rao
>> >
>> >
>> >.
>> >
>
>.
>|||> Could you please throw me some light on how others in the
> consulting field offer their work to clients and still
> safeguard their IP(Intelectual Proprty)?
You should start a new thread on that, with proper subject. That would
probably be the best way to poll. Also, programming is probably a better
group for that. I've used encryption just to "make it harder". But even .exe
file can be "decompiled", so technical solutions only takes you so far. The
general recommendation is to do it by legal measures.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rao" <chtvrao@.valona.com> wrote in message
news:07bf01c3a506$ee94ecb0$a401280a@.phx.gbl...
> Hi Tibor,
> Thanks for the details. I know the existence of these
> tools to decrypt the SPs. Anyway we have to live with it.
> Could you please throw me some light on how others in the
> consulting field offer their work to clients and still
> safeguard their IP(Intelectual Proprty)?
> Rao
> >--Original Message--
> >> We are in consulting and while we want to send updates
> to
> >> clients, we do not want to send the source code. So to
> >> send an encrypted Stored Procedure(s) only, I am looking
> >> at a way.
> >
> >There's really no way to send an encrypted stored
> procedure. The closes you
> >probably can come is to have your customers execute an
> exe file where the
> >CREATE statements are inside the EXE file. I.e., having
> the EXE file be the
> >"scrambler". Unfortunately, Profiler will show these
> statements, but on the
> >other side there are tools out there that crack this
> encryption, so if your
> >customer really wants to...
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Rao" <chtvrao@.valona.com> wrote in message
> >news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
> >> Thanks for the suggestions. While these give me clues
> >> related to the topic, my requirement is somewaht
> specific
> >> and it is like this.
> >>
> >> We are in consulting and while we want to send updates
> to
> >> clients, we do not want to send the source code. So to
> >> send an encrypted Stored Procedure(s) only, I am looking
> >> at a way.
> >>
> >> Any more suggestions Please?
> >>
> >> Rao
> >>
> >> >--Original Message--
> >> >For a non-data carrying object (everything except
> table),
> >> generate script.
> >> >To do this from code, use the DMO API.
> >> >
> >> >For a table, (I assume you also want data), you can
> >> generate script and also
> >> >use BCP, DTS or some similar method for the data.
> >> >
> >> >--
> >> >Tibor Karaszi, SQL Server MVP
> >> >Archive at:
> >> >http://groups.google.com/groups?
> >> oi=djq&as_ugroup=microsoft.public.sqlserver
> >> >
> >> >
> >> >"Rao" <chtvrao@.valona.com> wrote in message
> >> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
> >> >> Hi,
> >> >> Any suggestions on Backup / Restore of a select
> Table /
> >> >> Stored Procedure etc?
> >> >>
> >> >> Rao
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Hi Tibor,
Thanks for all the info. Let me see what I can do.
Rao
>--Original Message--
>> Could you please throw me some light on how others in
the
>> consulting field offer their work to clients and still
>> safeguard their IP(Intelectual Proprty)?
>You should start a new thread on that, with proper
subject. That would
>probably be the best way to poll. Also, programming is
probably a better
>group for that. I've used encryption just to "make it
harder". But even .exe
>file can be "decompiled", so technical solutions only
takes you so far. The
>general recommendation is to do it by legal measures.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Rao" <chtvrao@.valona.com> wrote in message
>news:07bf01c3a506$ee94ecb0$a401280a@.phx.gbl...
>> Hi Tibor,
>> Thanks for the details. I know the existence of these
>> tools to decrypt the SPs. Anyway we have to live with
it.
>> Could you please throw me some light on how others in
the
>> consulting field offer their work to clients and still
>> safeguard their IP(Intelectual Proprty)?
>> Rao
>> >--Original Message--
>> >> We are in consulting and while we want to send
updates
>> to
>> >> clients, we do not want to send the source code. So
to
>> >> send an encrypted Stored Procedure(s) only, I am
looking
>> >> at a way.
>> >
>> >There's really no way to send an encrypted stored
>> procedure. The closes you
>> >probably can come is to have your customers execute an
>> exe file where the
>> >CREATE statements are inside the EXE file. I.e., having
>> the EXE file be the
>> >"scrambler". Unfortunately, Profiler will show these
>> statements, but on the
>> >other side there are tools out there that crack this
>> encryption, so if your
>> >customer really wants to...
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Rao" <chtvrao@.valona.com> wrote in message
>> >news:053901c3a4cc$aa8fa490$a401280a@.phx.gbl...
>> >> Thanks for the suggestions. While these give me clues
>> >> related to the topic, my requirement is somewaht
>> specific
>> >> and it is like this.
>> >>
>> >> We are in consulting and while we want to send
updates
>> to
>> >> clients, we do not want to send the source code. So
to
>> >> send an encrypted Stored Procedure(s) only, I am
looking
>> >> at a way.
>> >>
>> >> Any more suggestions Please?
>> >>
>> >> Rao
>> >>
>> >> >--Original Message--
>> >> >For a non-data carrying object (everything except
>> table),
>> >> generate script.
>> >> >To do this from code, use the DMO API.
>> >> >
>> >> >For a table, (I assume you also want data), you can
>> >> generate script and also
>> >> >use BCP, DTS or some similar method for the data.
>> >> >
>> >> >--
>> >> >Tibor Karaszi, SQL Server MVP
>> >> >Archive at:
>> >> >http://groups.google.com/groups?
>> >> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >> >
>> >> >
>> >> >"Rao" <chtvrao@.valona.com> wrote in message
>> >> >news:08d901c3a44b$d8cd6df0$a501280a@.phx.gbl...
>> >> >> Hi,
>> >> >> Any suggestions on Backup / Restore of a select
>> Table /
>> >> >> Stored Procedure etc?
>> >> >>
>> >> >> Rao
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>
Subscribe to:
Posts (Atom)