March 3, 2009 at 9:13 am
I posted in SQL 2000 without any replies....We will be going to SQL2005 this quarter so methods in either version will help....
We have servers for each of 5 development environments. I have to restore to each one of the them on a scheduled based during releases. Basically a restore, drop and add some users for security, populate/de-populate some tables, update others tables.
Anyone have any suggestions for the best method? Right now I have a script that runs pretty well, but is done manually. When I pull into a scheduled job I have problems due to the size.
What is everyone else in this type of environment doing?
Thanks,
Suzanne
March 3, 2009 at 9:30 am
Have you tried turning your script into a stored procedure that you can then execute in a scheduled job?
March 3, 2009 at 11:02 am
Hi,
I have many similar scripts like Lynn suggest I chained them into Stored Procs. I have a database created on each of the Servers called DBManagement; in there I create any procedures and maintenance script that I might need on the script. And I try to keep that DB same across servers so all the DBA scripts are nightly bundled.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply