|
Home > Archive > Microsoft SQL Server forum > July 2005 > backup location
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Damn fool 2005-07-30, 1:23 pm |
| 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\) 2005-07-30, 1:23 pm |
|
"Damn fool" <teller_117@hotmail.com> wrote in message
news:gZOGe.7248$q23.1343220@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 2005-07-30, 1:23 pm |
|
"Damn fool" <teller_117@hotmail.com> wrote in message
news:gZOGe.7248$q23.1343220@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\fold
er\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/pr...backuprest.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
|
|
|
|
|