View Full Version : how to backup SQL Server to network driver


!accesser
02-01-2007, 06:39 PM
how to backup SQL Server to network driver?

backup database can not use on network driver.

some adivce?

Thanks.

boblarson
02-01-2007, 07:04 PM
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
02-01-2007, 08:02 PM
Thank boblarson for this tip,

Thanks.