Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

More SQL Server Interview Questions

what is a join? : Sql server database administration

0 Answers  


Do you know what is blocking?

0 Answers  


What does it mean if @@cursor_row returns a negative number?

0 Answers  


what is a correlated sub-query? : Sql server database administration

0 Answers  


Differences between Standby Vs No recovery?

2 Answers   Wipro,


What are the limitation of the Online Index Rebuild Operation?

1 Answers  


in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  


How to transfer a table from one schema to another?

0 Answers   MCN Solutions,


What is ms sql server service broker?

0 Answers  


What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,


What is a trigger?

7 Answers  


What is an index in sql?

0 Answers  


Categories