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
Why use sub query in sql server and list out types of sub queries?
What is difference between sql and sql server?
what's the maximum size of a row? : Sql server database administration
How retrieve field names from the table in SQL through JAVA code?
What is the fillfactor concept in indexes?
Explain the first normal form(1nf)?
What are key constraints?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain syntax for disabling triggers?
What is the user of Primary key?
Explain query editor regions
Explain about link server in sql server?
How to include date and time values in sql statements?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to create dbo table in sql server?