Network drive backup

Dear all,
I want to take backup of my Sql server 2000 databases on network drive but I
am unable to find the network drive only local drive are seen in Enterprise
Manager of my Sql server. Actually I have tried both by, maping my network
drive thru Domain/Administrator password as well as domain/users password
also but it will not showing my network drives.I am also changed my
Sqlserver services with this account also.
Kindly help, Thanx in advance.
Lokesh/Ravishrikrishna
BOL
Transact-SQL Reference\BACKUP
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:errRL%23lwFHA.1252@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I want to take backup of my Sql server 2000 databases on network drive but
> I
> am unable to find the network drive only local drive are seen in
> Enterprise
> Manager of my Sql server. Actually I have tried both by, maping my network
> drive thru Domain/Administrator password as well as domain/users password
> also but it will not showing my network drives.I am also changed my
> Sqlserver services with this account also.
> Kindly help, Thanx in advance.
> Lokesh/Ravishrikrishna
>
>
|||Hi Lokesh,
DO u have logon services permission on ur account.
U have to do backup by script.
from example backup database path='192.168.1.234\foldername'
dont use the drive name
when u share the folder add the username from which ur sql services are
running.
the mappnetwork drive may or may not work.
HTP
from
Doller
|||You will not anything else in EM other than physical disks connected to the
SQL Server.
You must type the UNC name \\servername\folder in the backup directory and
ensure that the SQL Logon account has both priviliges for the network drive
and network access.
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:errRL%23lwFHA.1252@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I want to take backup of my Sql server 2000 databases on network drive but
> I
> am unable to find the network drive only local drive are seen in
> Enterprise
> Manager of my Sql server. Actually I have tried both by, maping my network
> drive thru Domain/Administrator password as well as domain/users password
> also but it will not showing my network drives.I am also changed my
> Sqlserver services with this account also.
> Kindly help, Thanx in advance.
> Lokesh/Ravishrikrishna
>
>
|||Hi,
1.You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
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\sharenameXX\dbname.bak'
with init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:errRL%23lwFHA.1252@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I want to take backup of my Sql server 2000 databases on network drive but
> I
> am unable to find the network drive only local drive are seen in
> Enterprise
> Manager of my Sql server. Actually I have tried both by, maping my network
> drive thru Domain/Administrator password as well as domain/users password
> also but it will not showing my network drives.I am also changed my
> Sqlserver services with this account also.
> Kindly help, Thanx in advance.
> Lokesh/Ravishrikrishna
>
>
|||Lokesh Bhatnagar wrote:
> Dear all,
> I want to take backup of my Sql server 2000 databases on network drive but I
> am unable to find the network drive only local drive are seen in Enterprise
> Manager of my Sql server. Actually I have tried both by, maping my network
> drive thru Domain/Administrator password as well as domain/users password
> also but it will not showing my network drives.I am also changed my
> Sqlserver services with this account also.
> Kindly help, Thanx in advance.
> Lokesh/Ravishrikrishna
>
>
You'll have to use a UNC path to do it. If you create a backup device
from EM, you'll have to type in the unc path to where you wan't the
backup file. If you do it from QA, you have to use the backup command
with ...TO DISK = '\\YourServerName\BackupFolder\YourBackupFileName. BAK'
If I'm not wrong, you can't create a Maintenance Plan that backs up to a
UNC path.
Regards
Steen