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 is the sql profiler?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
What is the use of commit?
Explain what is dbcc?
what is bit datatype? : Sql server database administration
What is SQL Server?
What is an indexing technique?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to start sql server browser service?
Which is the main third-party tool used in sql server?
What are the advantages of user defined function?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)