how to backup SQL Server to network driver (1 Viewer)

!accesser

New member
Local time
Today, 12:56
Joined
Feb 2, 2007
Messages
2
how to backup SQL Server to network driver?

backup database can not use on network driver.

some adivce?

Thanks.
 

boblarson

Smeghead
Local time
Today, 12:56
Joined
Jan 12, 2001
Messages
32,059
In order to backup to a network drive, the SQL Server service must have security access to the other drive, so the SQL Server Service needs to have you set a log in for a network administrator. I can't explain how to do it at the moment as I don't have SQL Server installed on this computer so I can say exactly. But basically you go into Start > Control Panel > Administrative Tools > Services and right click on your SQL Server and select Log in As.
 

!accesser

New member
Local time
Today, 12:56
Joined
Feb 2, 2007
Messages
2
Thank boblarson for this tip,

Thanks.
 

Users who are viewing this thread

Top Bottom