When restoring databases in SQL 2005, i have to manually change the path for the Data and the Log file to be stored on a seperate partition each time i do a restore. Is there a way that i can change the default location for this, so i dont have to do this manually every time?
Right now its defaulting to this location:
C:\Program Files\Microsoft SQL Server\MSSQL\Data
I want it to default to this location:
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Don't think you can... using normal tools...
While the default ROOT path is configurable, it is used for a few things, and the restore browser does not have it's own default location that is immediately
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.