Interested to Buy Any Domain ? << Click Here >> for more details...
how can you move the master database
- 1 Answers
- 4713 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 |
wat is the main diff between sql server 2000and sql server 2005
what authentication modes does sql server support? : Sql server database administration
Differentiate between a local and a global temporary table?
What does null mean?
How to make a column nullable?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How can delete duplicate records in cte in sql server?
What is it unwise to create wide clustered index keys?
Scalability, Availability, Integration with internet, etc.)?
What is set nocount on and what is set nocount off?
query processing
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?
-
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)
