Copy Database

[jdonalds]

I have a live production database that I would like to use to create a test database with. What's the best approach for replicating the database (permissions and all) with a different name on the same instance of SQL Server?

Thanks,
Jeremy

 

[Corran007]

restore it with a different name

 

[mrdenny]

agreed. backup and restore will be your best bet.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[jdonalds]

Can I do this while users are accessing the live database?

 

[mrdenny]

Yes. Backups performed within SQL Server are done hot (with people using the database).

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[ryanlashway]

Does anyone know the code to do this with a schedualed job ?

 

[kishy]

YOu could use DB Maintainence Planner to create a backup and restore job with the time interval you want. This will create 2 jobs. You can monitor the jobs.

--Kishore

 

[mrdenny]

I've created an FAQ to show a good method for handeling database backups faq962-5722.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)