June 11, 2012 at 5:06 am
hi All,
Is it possible to add secondary files by referring the network path?
🙂
June 11, 2012 at 5:16 am
Nope, SQL wont allow files to be on network drives, they have to be on local storage only.
June 11, 2012 at 9:26 am
anthony.green (6/11/2012)
Nope, SQL wont allow files to be on network drives, they have to be on local storage only.
Don't think that is completely true. If I remember correctly, there is a trace flag that will allow it. I don't remember the flag, and I'm not sure if I would recommend using it as I don't know what problems you may encounter.
June 11, 2012 at 9:14 pm
It can be done on 2005 but I have no idea if it is a good idea since I have never tried it.
Description of support for network database files in SQL Server (KB)
I only know of the feature because I recently learned that great strides have been made in this area in SQL 2012, while researching the improvements in the new version, and that it is an area many customers ask about so expect more improvements in future versions.
SQL Server Can Run Databases from Network Shares & NAS by Brent Ozar[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply