Question

Locked

SQL Backup

By jmottolo ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Well if it won't let you through the front end

by Tony Hopkinson In reply to SQL Backup

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

Collapse -

Backups on a remote server

by AlexGreen86 In reply to SQL Backup

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.

Back to Networks Forum
3 total posts (Page 1 of 1)  

Hardware Forums