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

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  


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

0 Answers  


what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  


how can you initialize log miner?

0 Answers   Oracle,






Can we take incremental backups in datapump?

1 Answers  


Can you redefine a table online?

0 Answers   Oracle,


how to restore files with rman?

0 Answers  


How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  


An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  


what is meant by gateway

1 Answers   IBM,


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


Categories