August 10, 2009 at 3:03 pm
Dear All,
i need to do backup and save it on anthor backup server not localy.
can i do it from SQL direct or i need third Party and if i need it what is it name.
thanks alot.
August 10, 2009 at 3:11 pm
You can do this from SQL Server, but I would recommend creating the backup locally and then moving it off to another server. This will ensure that the backup operation can complete as quickly as possible by avoiding the network latency.
August 10, 2009 at 3:41 pm
thank you but how can i do it from SQL.
August 10, 2009 at 3:51 pm
BACKUP DATABASE YourDBName
TO DISK = 'your file path and name'
Use SQL Agent to schedule the backup command followed by a CmdExec command to move the file.
What have you tried?
August 10, 2009 at 5:09 pm
Hello,
I feel a dejavu!!!, the same answer for almost the same question.
You can backup / restore your database to / from share folder, just defining the UNC name on the BACKUP/RESTORE statement.
The BOL said:
If you are using a network server with a Uniform Naming Convention (UNC) name or using a redirected drive letter, specify a device type of disk.
you can try the following:
backup database MyDB
to disk = '\\shareserver\backup\backup.bak'
or
restore database MyDB
from disk = '\\shareserver\backup\backup.bak'
With Regards,
Victor Alvarez
http://sqlpost.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply