Answer / bhushan

Use BCP command 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.

Answer / jijo

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

Answer / amr

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

Answer / anwar hayat

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

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 the log file is a part of file group?

0 Answers  

What is nested transaction?

0 Answers  

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

Should you normalize audio?

0 Answers  

What is an indexed view?

0 Answers  

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

How get current date in SQL server 2000

6 Answers   Cap Gemini,

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers