restore db from network drive
Method1:
Use UNC names: \\servername\sharename\foldername\file.ext. The
account doing the backups - which is to say the account under which
SQL Server is running - needs appropriate rights to the share.
Method2:
In the management studio; go to query window and use RESTORE DATABASE
command. Make sure that you start sql server service using
a domain account which has access to remote share.
RESTORE DATABASE <DBNAME> FROM DISK='\\Servername\Share\filename.bak' with
stats=5posted on 2008-01-10 09:04 Above The Sky 阅读(176) 评论(0) 收藏 举报
浙公网安备 33010602011771号