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
Where sql server usernames and passwords are stored in a sql server?
Explain difference between control flow and data flow?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the limitations/drawbacks or ssrs 2008 r2?
What is the difference between truncate and delete commands?
Explain hostprotectionattribute in sql server 2005?
Tell me about builtinadministrator?
How to specify the collation for a character data type in ms sql server?
When would you use it?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to invoke a trigger on demand?
What are “unrepeatable reads”?
How to delete a login name in ms sql server?
How to make conditional sum in ssrs?
What is user-defined function?
