how can you move the master database

Question Posted / rushi

1 Answers
4710 Views
IBM, I also Faced
E-Mail Answers

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 is Cross Join and in which scenario do we use Cross Join?

0 Answers QuestPond,

Explain magic tables in sql server?

0 Answers

What is the use of MOVE keyword in restore command

3 Answers IBM,

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers Perot Systems,

diffrence between Cluster Index and non Cluster Index

3 Answers Wipro,

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers

How do I port a number to sql server?

0 Answers

How do you delete a trigger?

0 Answers

How to Rebuild Master database in sql server 2005.

2 Answers Wipro,

what is the difference between delete,drop and truncate