SQL Server Performance Forum – Threads Archive

Restore from Network Drive.

Hi,
Is it possible to Restore a DataBase from a Backup file located on the Network. Thanks. www.alpna.org

Yes as long as the SQL Server service account and the login used has the required privileges to access that file.
Refer to the Books online on RESTORE topic for more information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

Thank You for your reply Satya. I am new to this stuff can you explain "SQL Server service account" or provide me with some link for more information. I appreciate your help Thanks. www.alpna.org

see if these links help
http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.mspx
http://www.sqlservercentral.com/columnists/ckempster/sql_server_security.asp

]]>