1)how to Take Backup in sql server 2005 from Flash Drive



1)how to Take Backup in sql server 2005 from Flash Drive ..

Answer / ganeshanmsc

Backup To Flash Drive
=========================
ans:
BACKUP DATABASE test TO DISK = 'I:\backup.bak'WITH INIT

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More DB Administration Interview Questions

How to determine the service pack currently installed on SQL Server?

1 Answers  


1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  


What are the commands used in dcl? : sql server DBA

0 Answers  


What are the different types of indexes available in sql server? : sql server DBA

0 Answers  


What type of index should you use on a fact table?

1 Answers  






what are the differences of where and if in SAS?

0 Answers  


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  


by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


How do you resize a data file?

2 Answers  


what is the role of dip user in our database?

0 Answers  


What view would you use to determine free space in a tablespace?

3 Answers  


Datapump backup steps?

1 Answers  


Categories