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
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?
What authentication modes does sql server support? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
what is the use of recording information about current session?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you communicate with operating system files from oracle?
What are the commands you'd issue to show the explain plan for "select * from dual"?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can a session indicate its interest in receiving alerts?
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.
Query processing is slow(eg select query)how will u solve that
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the difference between clustered and non-clustered index? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
who owns the operating system files created by the utl_file package?