Welcome to Sign in | Help

Re: backup database SQL 2000 in shared folder !

  •  02-19-2010, 7:53 AM

    Re: backup database SQL 2000 in shared folder !

    I'm not sure where you got this information, dinakar. BOL specifically states: "The file must reside on one of the following devices: the local server on which SQL Server is installed, a Storage Area Network [SAN], or an iSCSI-based network." You are not allowed to use CREATE DATABASE with mapped drives or shared folders - you get an error:

    Msg 5110, Level 16, State 2, Line 1
    The file "\\whatever\alright\data.mdf" is on a network path that is not supported for database files.
    Magic Backup

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems