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

how can a session indicate its interest in receiving alerts?

795


what is asm?

820


How to start SQL Server in minimal configuration mode?

7372


which background process invoke at the time of upgradation tell me???

2478


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1923


What is a system database and what is a user database? : sql server DBA

843


How do you trace the traffic hitting a sql server? : sql server DBA

1172


when does an alert gets signaled?

790


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947


how can you initialize log miner?

858


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1759


How would you go about verifying the network name that the local_listener is currently using?

2987


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

792


What are the different sql server versions you have worked on? : sql server DBA

787


Where would you look for errors from the database engine?

2617