October 30, 2001 at 10:23 am
Is there a stored procedure that will allow me to duplicate a database before I load data into it? For example... I have a LIVE_DB and BACKUP_DB via ASP I would like to DUPLICATE LIVE_DB into BACKUP_DB. I have already programmed the switch over to the BACKUP_DB. After the duplication and switch I need to load in the new data and repopulate the full-text indexes.
Thanks for any help,
JNUNEZNYC
October 30, 2001 at 12:36 pm
You would have to write something to move all objects and data. There is a DTS task that will do this, perhaps you could schedule the package and use sp_start_job to run it from ASP.
Steve Jones
October 30, 2001 at 5:35 pm
You mean you want a copy of the live database without data?
You could create an empty live database by scripting the objects (or transfer via dts or dmo) then take a backup. The empty database could then be created by restoring the backup.
You could also create a database and run the scripts via osql.
If you want to transfer the objects via dmo here is a script that will do it - just change the objects transferrred and servers/databases/passwords.
http://homepage.ntlworld.com/nigelrivett/SQL-DMOTransfer.html
Cursors never.
DTS - only when needed and never to control.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy