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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2012-07-26 : 06:37:31
|
| I did a backup of a database (a full copy ) and then chose to restore it to a different server I'm getting an error when restoringthe backup set holds a database other then the existing 'dbname' databasewhat is the best way to copy a datbase to another server?I can't take the database down while i copy |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-26 : 06:40:15
|
| Sounds like you are trying to overwrite an existing database with a backup from a diferent name.Drop the existing database and it shuold let you restore.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-07-26 : 15:08:04
|
| Hello esthera,You can moving database to another server with several method.Backup-RestoreDetach-AttachCopy Database Wizardetc.Backup-Restore is the most perfer method becuase it does not need down time while backing up.Also you can restructure physical file path, as well as overwrite existing database on the same server or another server.You may facing a problem while restoring, becuase there is at least one user connecting and using database.You have an option to set database to be a single user mode, or restrict mode to solve problem above.Backup Set maybe hold more than one backup copy, even from a difference database name. Because it have option to overwrite or append copy of backup to backup setWhile you are backing up, please specify new backup-set to make sure you have a single backup copy in backup set.The last, please copy error message here. Maybe we help you more.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulCurrently be a DBA in worldwide hotel reservation. Experienced in top leading banking environment. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2012-07-27 : 01:40:25
|
| thanks that worked.Now I what I want to do is set the new one to be the main database and the old one to be a copy. I will do some read queries from the old one but all writing to the new one.How will this work with current triggers - do I need to delete them from the old.I'm reading on replication and it looks like transactional is what I want. Will this slow down the database? what else is important to know before I start with replication? |
|
|
|
|
|
|
backup and restore to another server