Can we backup to a remote drive?

Please let me know. Can we backup SQL Server database to a network drive?
Yes.
From the backup command you'll want to use a UNC drive reference such as
\\servername\share
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?
|||Yes, and you must use UNC format, not mapped drive.
btw, you still keep the tie?
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?
|||"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uGmoZZaHEHA.3240@.TK2MSFTNGP12.phx.gbl...
> Yes.
> From the backup command you'll want to use a UNC drive reference such as
> \\servername\share
Providing it's a disk share. Tape drives must be locally connected
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004
|||Hi,
There are Few Pre requisites to do this;
1. Should have share in the remote machine
2. You Should start SQL server using Domain user who got access to remote
machine Share
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?