January 16, 2008 at 5:35 am
I have several databases that I occasionally have to copy between servers. Since these databases are mission critical I can't use the detach/attach method. I'd rather not copy the backup files as a couple of them are 30G or more. Is there a way to use backup/restore to copy the db's? :ermm:
Tim
January 16, 2008 at 6:05 am
Hi Tim
If you are trying to move the database to other servers then why not try logshipping, there is a downtime between transfer, to minimise the down time one of the other best option is replication
January 16, 2008 at 6:11 am
Thanks, but due to the critical business need, no downtime is allowed. Log Shipping and Replication are not a feasible option due to the number of databases and the in-frequency of the tasks.
Another issue has just come to light, I now have the need to backup to a different server because the host server no longer has room. Buying additional disk is out of the question due to budget restrictions.
Tim
January 16, 2008 at 10:49 am
I was going to suggest mirrored backups before I read your second post. Now it seems you want to consider backing up over the network. We've done this by creating a backup device whose physical location is designated by a network file path.
This does make the backup process sensitive to network interruptions and it takes longer than backing up to local disk.
Greg
January 16, 2008 at 10:50 am
If you cannot afford any downtime, the only option is to backup/restore. Now, since you will be moving your backup files to a network share (make sure you have at least 1GB connection to this share), you can just copy the backup file from the network share to new system and restore.
You can also restore directly from the backup on the share, but this generally takes a lot longer depending upon how good the network connectivity to that share is.
If you have a fast network (fiber connected, iSCSI, 1GB+) this should not really be a problem. If not, you are going to have problems with both backing up and restoring from the share. In that case, you will need to do the following:
Backup to local storage
Copy from local to remote (share)
Remove local copy
To restore:
Copy backup file from remote to local
Restore from local backup
Remove local copy
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply