Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sreekanth
Need to do changes in the Startup Parameters
If you want to move your files you need to remove the
current entry and recreate your new entry with the correct
path. For example, To move the Master database log to
C:\test\. First delete the -l [path] by highlighting the
old parameter and choosing remove. Add the following entry,-
l C:\test\mastlog.ldf and click OK twice. Now, you will
stop SQL Server and move the mastlog.ldf to its new
location.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to list all login names on the ms sql server?
What is nolock hint in sql server 2008
What type of locking occurs during the snapshot generation? : sql server replication
What is data compression? : sql server database administration
What is failover clustering overview?
Explain user defined views?
Do you know what guidelines should be followed to help minimize deadlocks?
Explain the ways to controlling cursor behavior?
Explain different types of index?
What are three major types of constraints?
how to do partition in sqlserver
Your table has a large character field there are queries that use this field in their search clause what should you do?
Can you edit the .rdl code associated with a linked report?
When to use null data driven subscription?
What is store procedure?
