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 |
What are the properties of the transaction?
What is a Lock and let me know Different types of locks?
What is merge statement?
What is the purpose of using COLLATE in a query?
Describe triggers features and limitations?
What are the encryption mechanisms in sql server?
Scalability, Availability, Integration with internet, etc.)?
When to use Inner join & when to use subquery?
What is apply operator in sql?
What is ssl in sql server?
Explain log shipping and mention its advantages.
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that