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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2005-11-28 : 23:32:43
|
| HiHow can i copy database to another name.I have acct database now i want to copy acct database to oldacct database. How can i do this.thanksasm |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-29 : 00:09:09
|
| Probably easiest way is to backup the acct database and restore it to the oldacct databaseKristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-29 : 01:23:49
|
| If both are of the same structures and want to copy the data then use DTSMadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-11-29 : 04:10:50
|
quote:
Originally posted by Kristen
Probably easiest way is to backup the acct database and restore it to the oldacct databaseKristen
easiet |
|
|
|
|
|
|
copy database