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

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:
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 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)  

Related Discussions

Related Forums