Interested to Buy Any Domain ? << Click Here >> for more details...
how can you move the master database
- 1 Answers
- 4790 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How to use union to merge outputs from two queries together in ms sql server?
What is public role in sql server?
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
how will add additional conditions in sql?
0 Answers Amdocs, Apps Associates,
When a primary key constraint is included in a table, what other constraints does this imply?
If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.
How does using a separate hard drive for several database objects improves performance right away?
How many types of schemas are there?
What is the full form of dql?
What are extended events in sql server?
What happens if null values are involved in arithmetic operations?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
-
Oracle (3253) - 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)
