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
- 10344 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 do you mean by an execution plan? Why is it used? How would you view it?
What are the main sources of data?
What does null mean?
What is sql injection? How to protect against sql injection attack?
What are locks in sql?
How many tables can be joined in SQL Server?
How column data types are determined in a view?
How do you create a data source?
How to download and install microsoft sql server management studio express?
What is a dbms wizard?
What are the types of normalization?
What command is used to rename the database?
How to sort the query output with order by clauses in ms sql server?
What is report server project?
According to you what goes into making the best database administrator? : sql server database administration
