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
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.
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a crs resource?
what are the benefits of flashback feature?
how can you enable flashback feature?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can you implement fine-grained auditing?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
how can you record information about current session?
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
what is asm?
what do you understand by fine-grained auditing?