Viable quick restore cheat?

[mutley1]

Hi guys,

SQL 2000

I have limited space on my snad box server and am testing multiple delete functions on a 10GB DB. Have a backup of the best cutdown I can get but it is tedious waiting 20 mins for it to restore to do next full test run.

Q. If i get it to a decent start state, detach it, take a COPY of the MDF attach it, do a test run, detach it, replace with copied MDF and attach again, would that suffice IYHO?

Cheers,

M.

 

[mrdenny]

Yes it would. You'll need to copy the mdf and ldf files, as well as any ndf files as well.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[mutley1]

thanks Denny