how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
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 sql delete command?
Describe how to use the linked server?
What is the purpose of object explorer and its features? : sql server management studio
List all the types of user-defined functions?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How to enable/disable indexes?
how you can get the list of largest tables in a database? : Sql server administration
Why people hate cursor?
How to create an index on a view?
What is a deadlock and what is a live lock?
How to create a trigger for insert only?
What is table value parameters (tvp)?
How can I check that whether automatic statistic update is enabled or not?
What are different types of statements that are supported by sql?
Are connections to sql server encrypted?