how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
- 6 Answers
- 10743 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 do I start sql server 2017?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Why use identity in sql server?
How to connect php with different port numbers?
What is clustered index
Can you index views?
List out the different types of locks available in sql server?
What is sql or structured query language?
What is temporary table in sql server? Why we use temp table?
what is spatial nonclustered index
Where can you add custom error messages to sql server?
How do I create a trace in sql server?
What is the difference between upgrade and migration in sql server?
What is in place upgrade in sql server?
What is the difference between for xml raw and for xml auto?
