Tell me more ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a database in MS SQL Sever 2005 Express. I need to make a duplicate of it to test some upgrade scripts. I've tried to backup and restore to a new database, and it fails because it can tell the databases are different. I don't see a way to script out the entire database, otherwise I'd try that. What is the best way to make a copy of an existing database on the same machine.

share|improve this question
This question is purely about system administration, and should be asked on serverfault.com. If you revise the question and it meets the criteria listed in the FAQ, please flag this for moderator attention so it can be re-opened. – Tim Post♦ Aug 5 '10 at 15:15
Yeah, I'm not clear where the line is between the two. It is for managing a website, so it seems to be on-topic here. None the less, I've posted it on serverfault. – drye Aug 5 '10 at 16:20

closed as off topic by Tim Post♦ Aug 5 '10 at 15:15

Questions on Webmasters Stack Exchange are expected to relate to webmastering within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

Browse other questions tagged or ask your own question.