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 a data collection table?
what is the difference between table and view
How to execute stored procedure and set temp table in sql server?
What is the difference between ddl and dml?
What is the purpose of self join?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Why do you want to join software field as you have done your BE in Electronics?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
How can we check the sql server version?
How do we rollback the table data in SQL Server
Do you know what are the ways available in sql server to execute sql statements?
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)