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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways you can create databases in sql server? : sql server DBA

591


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2383


Why does Oracle not permit the use of PCTUSED with indexes?

2318


What is dcl? : sql server DBA

639


How to start SQL Server in minimal configuration mode?

6938






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

1518


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1857


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

698


What are the steps you will take to improve performance of a poor performing query?

2411


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

569


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2963


What are the different types of upgrades that can be performed in sql server? : sql server DBA

676


what is the use of ocr?

588


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1967


What is the difference between clustered and non-clustered index? : sql server DBA

536