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 |
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
Explain different types of index?
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
What command do we use to rename a database?
What are unicode character string data types in ms sql server?
Explain the difference between function and stored procedure?
What are tables in sql server?
Explain different types of collation sensitivity?
Write a SQL query to delete a table?
What are cursors stored procedures and triggers?
what is a correlated sub-query? : Sql server database administration
Which system tables contain information on privileges granted and privileges obtained