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
how can a session indicate its interest in receiving alerts?
what is asm?
How to start SQL Server in minimal configuration mode?
which background process invoke at the time of upgradation tell me???
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
What is a system database and what is a user database? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
when does an alert gets signaled?
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.
how can you initialize log miner?
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.
How would you go about verifying the network name that the local_listener is currently using?
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Where would you look for errors from the database engine?