Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is query optimizer in sql server?
What is de-normalization and what are some of the examples of it?
Can sql servers link to other servers?
What is enhanced database mirroring in sql server 2008?
How many triggers you can have on a table?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Can you type more than one query in the query editor screen at the same time?
How many categories of data types used by sql server?
Mention a few common trace flags used with sql server?
How can you ensure that the database and sql server based application perform well?
Can you name a few encryption mechanisms in sql server?
How you can change a cross join into an inner join?
What is default constraint in ms sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
