backup and restore script

I want to be able to create a development database based on our live databas
e
-- on an ongoing basis. I think the easiest way is to backup the live
database, and restore it as a different name. Because I will be doing this
often, I would like to run this as a script.
Does anyone have a script that would do that ?
Is this a good way to create a development database ?
Thanks,
Craig"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:FB8C7E76-586B-4902-90BF-7925C70B6299@.microsoft.com...
> I want to be able to create a development database based on our live
database
> -- on an ongoing basis. I think the easiest way is to backup the live
> database, and restore it as a different name. Because I will be doing this
> often, I would like to run this as a script.
> Does anyone have a script that would do that ?
> Is this a good way to create a development database ?
> Thanks,
> Craig
Works well if you need up to the second. If not, just grab the last db
backups and restore them.
Take a look at the BACKUP DATABASE and RESTORE DATABASE commands in the BOL.
I do this often myself as I need to ensure changes apply properly from
various database versions of our system.
I have 22 code bases to choose from now. (Gakk)
Each set of restore commands are currently saved as a .sql file.
I even included a generic kill sproc to remove any users from the databases
that will be update.
RestoreVer_2.1.1.10.sql
RestoreVer_2.1.1.11.sql and so forth.
Rick Sawtell
MCT, MCSD, MCDBA