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
- 10124 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
how can u get last observation in an unknown dataset ?
How are the unique and primary key constraints different?
What is rtm version in sql server?
What is an execution plan? When would you use it?
How does a profiler work?
What are the different authentication modes in sql server? How can it be changed?
What are the general features of sql server management studio? : sql server management studio
What is create command?
How do I debug a stored procedure in sql server?
What is difference between count (*) and count 1?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are the types of subquery?
What is history table in sql server?
What is RAID? What are the different types of RAID configurations?
When you use @@error and try-catch?
