1)how to Take Backup in sql server 2005 from Flash Drive
Answer / ganeshanmsc
Backup To Flash Drive
=========================
ans:
BACKUP DATABASE test TO DISK = 'I:\backup.bak'WITH INIT
| Is This Answer Correct ? | 0 Yes | 6 No |
What is a correlated sub-query? : sql server DBA
How can we see the database version in os level
1)how to Take Backup in sql server 2005 from Flash Drive
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
Datapump backup steps?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
What is the default port no on which sql server listens? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Give two methods you could use to determine what DDL changes have been made.
What is the importance of a recovery model? : sql server DBA
why do we give pctfree and pctused in create table statement?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)