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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / arun

6 Answers
10301 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / bhushan

Use BCP command in SQL server.

Is This Answer Correct ?

5 Yes

2 No

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

Answer / 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

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

Answer / jijo

Take the full backup of sysdatabse and specify backup
location into d:\

Is This Answer Correct ?

1 Yes

1 No

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

Answer / amr

1st u have to stop sqlserver then u can catch file and copy
it anywhere !!

Is This Answer Correct ?

0 Yes

0 No

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

Answer / anwar hayat

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / samar

plz explain in brief,

if u can send me screen shots for process , it ll be good
for undetstandin
mail id: summer_sinha@yahoo.com

Is This Answer Correct ?

0 Yes

1 No

Post New Answer