Welcome to
Sign in
|
Help
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
Intrebari generale
»
Re: backup database SQL 2000 in shared folder !
Re: backup database SQL 2000 in shared folder !
02-19-2010, 7:53 AM
kalyer
Joined on 09-15-2009
db_datawriter
Re: backup database SQL 2000 in shared folder !
Reply
Quote
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
Report abuse
View Complete Thread