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 |
|
benwilson
Starting Member
6 Posts |
 Posted - 2005-01-19 : 18:33:42
|
| Hey All,Ok, my next backup question...we are going to set up a replication server to replicate our main database...(which will be another major learning experience for me!)Taking backups on the replication server would obviously reduce the load on the live server, but would we be able to restore the backups of the replication server to the live one?Thanks,Ben |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-01-19 : 18:44:40
|
The database is server independent restoring backups should not be a problem... I have not implemented replication you will have to have the database in single user mode so you will probably have to turn off the service before doing the restore as it would be maintaining a connection. |
 |
|
|
|
|
|
backups- live vs replication server