- Follow via:
- RSS
- Email Alert
Question
0
Votes
SQL Backup
Is there a way to run a SQL backup job in SQL 2005, through Maint Plans, but to a hard drive on a different server?
19th Jun 2007
Answers (2)
0
Votes
Well if it won't let you through the front end
just do it as sql command
http://technet.microsoft.com/en-us/library/ms179313(SQL.90).aspx
A page or so down in above 'back up to a network device'
Don't forget the account the sql server service is running as needs permissions on the drive.
I'd recommend using UNC as a opposed to a drive letter as well.
Note there used to be a substantial performance penalty doing this, I used to back up to a local disk and then move the file across the network. Back up operation took considerably longer across the network, though things might have improved a bit since then.
Personally I'd look at backing up to a local disk
http://technet.microsoft.com/en-us/library/ms179313(SQL.90).aspx
A page or so down in above 'back up to a network device'
Don't forget the account the sql server service is running as needs permissions on the drive.
I'd recommend using UNC as a opposed to a drive letter as well.
Note there used to be a substantial performance penalty doing this, I used to back up to a local disk and then move the file across the network. Back up operation took considerably longer across the network, though things might have improved a bit since then.
Personally I'd look at backing up to a local disk
19th Jun 2007
1
Vote
Backups on a remote server
You can create a Job that runs this T-SQL statement:
BACKUP DATABASE AdventureWorks
TO DISK = '\\BackupSystem\BackupDisk1\AW_backups\AdventureWorksData.Bak';
However, you'll have to make sure that the username under which SQL Agent runs has permissions on the remote server.
You can also try this tool http://sqlbackupandftp.com that allows you to run backups and send them to a remote server LAN or FTP. You can also schedule backup jobs and receive detailed reports on your email.
BACKUP DATABASE AdventureWorks
TO DISK = '\\BackupSystem\BackupDisk1\AW_backups\AdventureWorksData.Bak';
However, you'll have to make sure that the username under which SQL Agent runs has permissions on the remote server.
You can also try this tool http://sqlbackupandftp.com that allows you to run backups and send them to a remote server LAN or FTP. You can also schedule backup jobs and receive detailed reports on your email.
Updated - 7th Jul 2011
