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
what is the difference between a primary key and a unique key? : Sql server database administration
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What do you understand by a stored procedure?
What are the dmvs?
How many partitions a clustered index has by default in sql server 2012?
Detail about query optimizer?
What are the different types of normalization?
Can we do dml on views?
What is key set driven?
How to count rows with the count(*) function in ms sql server?
Explain what are sparse columns?
How to create a large table with random data for index testing in ms sql server?
what are cursors? : Sql server database administration
Who developed sql server?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?