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
How do I find the default sql server instance?
How to select some specific rows from a table in ms sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How many replicas are maintained for each sql azure db?
What is sqlservr.exe - process - sql server (sqlex?press)?
Explain transaction server distributed transaction?
How to transfer data from a cursor to variables with a "fetch" statement?
Do you know the cursor optimization tips?
How to use group functions in the select clause in ms sql server?
Explain the first normal form(1nf)?
What are the differences between user defined functions and stored procedures?
What is the purpose of optimization?
What are three major types of constraints?
How many types of attribute relationships are there? : sql server analysis services, ssas
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?