February 26, 2003 at 8:17 am
I am a complete novice on SQL Server, please help. I have created a database in SQL Server complete with stored procedures and jobs. I now wish to install copies of this database onto servers outside the office preferably with as little input from users as possible. Do I take a “back-up” of the original database and then “restore” on the new servers? Should I write a program in a Visual C++ to do the restore?, if so any suggestions?, or are there easier methods of restoring with the minimal of user input?
Many thanks
Steve
February 26, 2003 at 8:45 am
A backup and retore will work. Or you could detach the database, make copies of the physical log and data files, and copy them to the external box, and then attach the database.
Might check out these articles:
http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp
http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
February 27, 2003 at 2:57 am
Greg, many thanks for your prompt reply, I have decided to use the restore method but is there a method of automating the restore where there is no/minimal of input required by a user.
Steve
February 27, 2003 at 11:23 am
Yes. One optin would be to have a job on the from server that does the following:
Step 1) Takes a backup of the database.
Step 2) Runs sp_start_job via a linked server to start the restore process on the target server.
Now of course you will need to have a job on the target server, and deal with either shipping the backup or using a network drive for the backup.
Hope this gives you some ideas. There are many other ways to do this, via FTP and monitoring for when the backup is placed on the FTP server and what not. If I knew your network/firewall architecture might have a better approach at a solution that will work for you.
Hope this helps.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply