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 |
|
loamguy
Starting Member
15 Posts |
 Posted - 2008-01-21 : 13:54:27
|
| Hi all,New member here...I've used SQL2000 before (Enterprise Mgr, Query Analyzer), but, now I'm at a company without any DBAs so I'm on my own as far as administration goes which I haven't done before on SQL2000.We have a production database about 100MB in size. As of now there is no development DB. They won't pay for a new server, so I'd like to create a new development database on the same prod server. Then, I want to copy the existing prod database into the new dev DB.I've read up some on DTS, but I wanted to check with the community to see if anyone had other recommendations or if this is the best way to go about it.Also, is this a process that should run at off-hours? Would the copy of production lock the DB up?Thanks a lot... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-21 : 14:05:02
|
| use backup/restore instead.-ec |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-21 : 14:10:28
|
| Generally speaking you should do this during a maintenance window,making sure you've taken appropriate backups etc. As eyechar has mentioned do a BackUp Restore, being careful to rename your db ( as it's on the same server, and also creating different MDF / LDF file pathsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-21 : 14:22:17
|
| keep in mind this is a fairly dangerous thing to do becuase you can get easily confused and think you are working on the dev database when you are actually working on the prod database in the same instance.so, be really careful with dropping objects or deleting data with this setup.-ec |
|
|
|
loamguy
Starting Member
15 Posts |
Posted - 2008-01-21 : 14:54:09
|
| Ok all, thanks for the tips! |
|
|
|
|
|
|
|
|
Copying one database to another