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

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2250


What authentication modes does sql server support? : sql server DBA

947


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

811


what is the use of recording information about current session?

836


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

877


how can you communicate with operating system files from oracle?

827


What are the commands you'd issue to show the explain plan for "select * from dual"?

2031


suppose you want to audit specific activities on sensitive data. How can you achieve that?

800


how can a session indicate its interest in receiving alerts?

814


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2339


Query processing is slow(eg select query)how will u solve that

7300


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1813


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

812


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2341


who owns the operating system files created by the utl_file package?

849