Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Conjurer
Starting Member
30 Posts |
 Posted - 2005-12-09 : 17:31:35
|
| I want to make a copy of our production database so I can do some testing stuff on it...I basically want to just save the complete database with a name like testingXYZ. Can I just do that through the normal file explore manager or is there some SQL Things I need to do? |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-12-09 : 18:04:01
|
| Just make a backup of your database and restore on your test server. Look in the FAQ Sticky in this forum:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210[/url]Re post here if you dont find what you need.Nathan Skerl |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-10 : 02:08:32
|
| http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546MadhivananFailing to plan is Planning to fail |
|
|
|
Conjurer
Starting Member
30 Posts |
Posted - 2005-12-10 : 13:02:04
|
Thanks!Those links should do the trick! |
|
|
|
|
|
|
Making a copy of a database