how can you move the master database



how can you move the master database..

Answer / 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

More SQL Server Interview Questions

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,


What is instead of dml trigger?

0 Answers  


diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,


What is a result set object returned by odbc_exec()?

0 Answers  






What are trace flags?

0 Answers  


do views contain data ?

0 Answers   MCN Solutions,


What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,


What is an entity-relationship diagram (erd)?

0 Answers  


What is row_number function?

0 Answers  


How do I install only the client tools of sql server 2000?

0 Answers  


What is transaction server explicit transaction?

0 Answers  


Categories