Create a test database server

Question

Create a test database server

whitesql

Ten Centuries

Points: 1237
More actions
September 18, 2014 at 12:19 am

#296317

Hi!
How do I create a test database server with the exact database in the production?
Please help. Thank you!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

Backup / restore?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

whitesql Ten Centuries Points: 1237 More actions · Answer 2

Hi Koen,

I'm trying to restore the backup on my test server but im getting an error. ..mdf is claimed by adv. The WITH MOVE clause can be used to relocate one or more files.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

Take a look at this:

http://stackoverflow.com/questions/14953848/database-restore-failing-with-move

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP