how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.

Answer Posted / anwar hayat

Stop MS SQLServer Services and copy mdf ldf files in desire
location.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe how to use linked server?

709


Can we add an identity column to decimal datatype?

778


What is sql profiler. What are the default templates with it? : sql server database administration

725


What are various limitations of the views?

816


How to receive output values from stored procedures?

740


How many database files are there in sql server 2000?what are they?

785


How to change the data type of an existing column with "alter table" statements in ms sql server?

757


Explain identity in sql server?

740


what is the Ticketing tool used in Wipro technologies at Bangalore...???

7848


How do I start sql server 2016?

706


What is the difference between NOROW and LOCKROW?

2502


what is database replication? : Sql server database administration

742


What is sql collation?

852


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

749


How to delete an existing database user?

772