how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
- 6 Answers
- 9202 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
Explain linked server in sql?
What are the types of resultset?
What are the steps to insert a table?
How to count groups returned with the group by clause in ms sql server?
What is dknf in normalization form?
Tell me what is de-normalization and what are some of the examples of it?
How use inner join in sql server?
What are different types of raid configurations? : SQL Server Architecture
Explain the purpose of indexes?
How to use clusters?
What is delete query?
Can a trigger be created on a view?
What are different types of join?
How can you tell if a database object is invalid?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
