backup location

[Damn fool]

Hi again,

I am able to schedule a backup and default it to the server. However, is
there an option or a way to locate the backup somewhere else on the network?
regards,
gilbert

[Greg D. Moore \(Strider\)]

"Damn fool" <te********@hotmail.com> wrote in message
news:gZ********************@news20.bellglobal.com. ..

Hi again,

I am able to schedule a backup and default it to the server. However, is
there an option or a way to locate the backup somewhere else on the network?
Yes. You need to use a UNC and make sure the SQL Agent has rights on the
server you're writing to.

We use a snap server for this quite a bit.


regards,
gilbert

[Simon Hayes]

"Damn fool" <te********@hotmail.com> wrote in message
news:gZ********************@news20.bellglobal.com. ..

Hi again,

I am able to schedule a backup and default it to the server. However, is
there an option or a way to locate the backup somewhere else on the
network?
regards,
gilbert

Provided that the MSSQL service account is a domain account with write
access to \\server\share, then you can use a command like this:

backup database SomeDB to disk = '\\server\share\folder\somedb.bak'

See BACKUP and "Setting Up Windows Service Accounts" in Books Online. Note
that according to this white paper, MS do not recommend backing up to a
network drive because of the possible performance and connectivity issues:

http://www.microsoft.com/technet/pro...ackuprest.mspx

In fact, if your database is quite small, then backing up to a network drive
is probably fine (you can always back it up again if the job fails), but if
you have large databases or if the backup job is critical, then it might be
safer to back up to a local drive first, and then copy the file to a network
location.

Simon