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

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,


Explain different types of index?

0 Answers  


What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,


What command do we use to rename a database?

0 Answers  


What are unicode character string data types in ms sql server?

0 Answers  






Explain the difference between function and stored procedure?

0 Answers  


What are tables in sql server?

0 Answers  


Explain different types of collation sensitivity?

0 Answers  


Write a SQL query to delete a table?

0 Answers   Amdocs,


What are cursors stored procedures and triggers?

0 Answers  


what is a correlated sub-query? : Sql server database administration

0 Answers  


Which system tables contain information on privileges granted and privileges obtained

1 Answers  


Categories