Consider a server that has a single scsi drive and SAN drive attached to it. Clearly, the user databases will be deployed on the SAN drive. Should the same be done to system databases or keep them on c:?
Thanks in advance
View Complete Post
Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.
Brian A. Randell
MSDN Magazine February 2007
I had successfully restored sql 2000 database to sql 2005. It works like charm
Now i am creating a database model in MVC
I follow these steps
Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name
But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error
"A network-related or instance-specific error while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.
Kindly help me with this