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
what are the performance views in an oracle rac environment?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you implement fine-grained auditing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How can you control the amount of free space in your index pages? : sql server DBA
what do you understand by fine-grained auditing?
How do you trace the traffic hitting a sql server? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different ways you can create databases in sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution