Backup through LAN
-
Please help me out to take the SQLbackup through network....
Data is of 10GB size......
Thanks in advance
Deep
-
Needs some testing (restoring the backup), a good network connection. (the smallest thing could make the backup corrupt making it a high risk operation)
A mapped (X
lan-share ought to work.Sure you can't store the backup locally and copy it afterwards?
-
I Backup ALL my databases locally and to a Network SHARE.
I use \\Servername\sharename\foldername for the Backup Destination
Make sure that whatever Domain Account you are using to Start SQL Server and the Agent have permissions to the share.
-
I have had big problems doing SQL backups over the wire. Sql 2000 and Win Server 2003. There was an issue with SMB (Server Message Blocks?) where it looked like the destination server 'was not there'. MS advised a colleague of mine to back up locally anything over a few GB and then put to tape so we put in 1 TB Firewire drives which have worked well. They then go to tape.
-
I use pkzip command line on local backups and them copy them across the LAN. They zip to about 20% of thier size. You must use pkzip to unzip a file that large. I added steps to the backup jobs to do this.
-
Agree with Adam. Backup locally, zip, and xcopy all from TSQL (if you have xp_cmdshell enabled).
If you don't have room on the local server, you can backup to UNC path. Use backup command TO DISK='\\...' Of course, like so many have said you now have network issues to deal with, but in a strong network it should work OK. We back up a 100GB pure image database this way. Zip will not help on these, and it needs to get on tape so...
Terry
-
It is simple.
1.Map the Network folder
2.Using EM backup the Database. you will be getting the Map drive in your Select List.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply