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?
Answer / kamal
if full backup has been taken , you can restore at any
time . if differential has been taken checkup the last full
backup date then verify diff. backup has been taken
immediate after that or not if not find the date & time for
which it was left and take diff. backup of that .
| Is This Answer Correct ? | 4 Yes | 0 No |
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the steps you will take, if you are tasked with securing an SQL Server?
who owns the operating system files created by the utl_file package?
what functionality does oracle provide to secure sensitive information?
What is the difference between clustered and non-clustered index? : sql server DBA
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to determine the service pack currently installed on SQL Server?
the process of adding a cpu in sql server is called..?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the default port no on which sql server listens? : sql server DBA
Give two examples of how you might determine the structure of the table DEPT.
What view would you use to determine free space in a tablespace?
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)