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
- 10398 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 are the differences between stored procedure and the dynamic sql?
What are the different types of collation sensitivity in sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What are sql azure firewall rules?
What do you understand by the denormalisation?
What are two difference between sql azure and azure tables?
How to get a list all databases on the sql server?
What are the different types of triggers in SQL SERVER?
What is difference between cte and view?
Explain what is the difference between union and union all?
What are the new features are introduced in sql server 2012 reporting services?
When does a workload on SQL Azure get throttled?
What is measure group, measure? : sql server analysis services, ssas
What is the contrast between sql and mysql?
What are alternate keys?
