Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Configure Logshipping with Transact-SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-08-14 : 08:05:20
Aldo writes "I configured Logshipping with the wizard of the enterprise manager. I have to do it for 90 databaseses. I found the stored procedures sp_add_logshipping.... but I couldn't find the dependencies under those procedures. Can anybode explain me ther order of the procedures?
Thank you!
Aldo"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-14 : 11:14:42
Configuring log shipping is not easy using T-SQL. I was going to do this as well, so I decided to run SQL Profiler and then run the wizard. After I was done setting up log shipping, I went to SQL Profiler and took a look at all of the commands that were required to setup log shipping. You can do the same.

Tara
Go to Top of Page
   

- Advertisement -