rkinfo writes "How to set up sql server to save back up of sql server databse to remote disk on network ? My sql server host (SQL server 2000 on windows 2000) is full and I want to start taking weekly backup to other machine on network but I am unable to see any other machine during scheduling 'recurring' backups."
keep in mind that when you backup to a remote share you will not be able to browse to that share in Enterprise Manager to pick out a file when you attempt a restore. You will have to manually key in the path and file name for the restore.
This is not a big issue, just something to keep in mind. I suggest you do a couple of practice runs with backups/restores to familiarize yourself with the procedure.
Perhaps consider using a Compressed Folder to store the backups on the machine itself? IME that saves about 50% of the disk space, and I have never had a problem with BACKUPS on compressed volume (there are some reports of problems, but I think they are very few and far between)
Backing up to a remote share over the network will also take significantly longer the writing to a local disk. If the database is of any size at all, this might not be a good idea. I'm not saying don't do it, but you might want to test heavily as suggested above. Also, SQLLiteSpeed is cheap...
Backup SQL server to remote disk
Posted - 10/04/2005 : 08:03:46
