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
Define inner join in sql server joins?
What is an sql server agent?
ow to bring suspect mode datbase online from scratch
What is an execution plan? How would you view the execution plan?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How do I find the default sql server instance?
Explain the phases a transaction has to undergo?
How to view the error log for any specific instance? : sql server database administration
What is Cross Join and in which scenario do we use Cross Join?
What do you mean by 'normalization'?
What is the difference between count () and rowcount ()?
How can change procedure in sql server?
How will you find out if there are expensive SQL statements running or not?
What is subquery in sql?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
