Posted by Neil on 11/13/07 20:39

And if there's an existing db with that name, it will overwrite it entirely?

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:F4D3C4C1-35C2-4CFE-81C0-A7AF434911AA@microsoft.com...
> I'd go for backup and restore. When you do the restore, specify a
> different database name and use the MOVE option of the RESTORE command to
> specify new database file names.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Neil" <nospam@nospam.net> wrote in message
> news:EAb_i.20588$Pv2.7236@newssvr23.news.prodigy.net...
>>I need to create a test database on the live server for performance
>>testing. From time to time, as structural modifications are made to the
>>live database, I'd like to be able to delete the test database and replace
>>it with a new copy of the live database. Is there a simple way to do this
>>with a script or other? Thanks!
>>
>

[Back to original message]