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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.