Hi Everyone,

I have small question in regards to taking a backup.I have a database <DB1> for which i need to take the backup.But i want the .bak file to be in a different server as i dont have enough disk space to take that back up on the same server.

So generally we give the command as

BACKUP DATABASE DB1 TO DISK ='D:\........bak'                                                                                                                     

WITH INIT,STATS=10

But now I need to take a backup to differnt server so what is the command for that ???

Thanks in advance

BACKUP DATABASE ... TO DISK='myserver\myshare\...'

One thing to remember is that the account SQL Server and Agent runs under should (or must?!?) be a user account, not the system account and this account needs read and write permission.

you need a couple of slashes in front of myserver (network share name) like so:

BACKUP DATABASE ... TO DISK='\\myserver\myshare\...'