Interested to Buy Any Domain ? << Click Here >> for more details...
how can you move the master database
- 1 Answers
- 4682 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 |
What type of locking occurs during the snapshot generation? : sql server replication
State the difference between local and global temporary tables?
why would you call update statistics? : Sql server database administration
What is table join?
Difference between DELETE and TRUNCATE?
What is a primary index?
Does hive support indexing?
What are the different types of backups avaialabe in sql server 2005?
Your table has a large character field there are queries that use this field in their search clause what should you do?
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
What happens if date-only values are provided as date and time literals?
What is full form of XP ?
42 Answers Cap Gemini, Infosys, Microsoft, Oracle, Reliance,
-
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)
