Interested to Buy Any Domain ? << Click Here >> for more details...
how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
- 6 Answers
- 10307 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / harish sharma
Sysdatabase table is the part of master database.
So u need to change the location of master database in this
case. which can be don in the database properties ->
statring parameters. Then u have to change the location of
all three files. master.mdf, master.ldf, and error file.
Then after stoping SQL agent you can move files.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What does REVERT do in SQL Server 2005?
What is sql stored procedure?
Can you explain powershell included in sql server 2008?
What does COMMIT command do?
what is sql server? : Sql server database administration
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is the difference between for xml raw and for xml auto?
How much is a sql server license?
How can sql injection be stopped? : sql server security
How to count groups returned with the group by clause in ms sql server?
Explain system rowset functions?
What is the latest version of microsoft sql server?
How to retrieve error messages using odbc_errormsg()?
What is tablesample?
How to send a ssrs report from ssis?
