September 18, 2000 07:18 PM

Practice Questions--Restoring Databases

Rating: (0)
SQL Server Magazine
InstantDoc ID #15621

1. You have the truncate log on checkpoint option set for a small database, which you have to restore after a failure of the hard disk on which the data resides. Which of the following statements are true?

  1. You can restore a full backup to this database.
  2. You can restore a differential backup to this database.
  3. You can restore the current transaction log (assuming that it was on a different disk) if you back up the log before beginning the re...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS