question

RBarryYoung avatar image
RBarryYoung asked

Database Backup & Restore

I have participated in several of the StackOverflow sites, and one of the things that I have noticed is that there is a real "bootstrap" problem in the beginning. There really needs to be a certian minimum number of active members with a minimum number of points before it starts to work effectively. In the interests of addressing this, (and unless the powers that be object) I will be posting challenge questions based on some of the older SqlServerCentral Questions Of The Day. The first answer which is correct will be marked as accepted (15 points). For the most part I will not be presenting the questions as multiple choice, as they originally were.

NOTE:

For the time being, I am asking that only those with less than 50 points attempt to answer these questions. This series is intended to give potential new answers, who may not have legitmate questions of their own, a way to get enough points to be able to effectively interact on the site as an Answerer. The two most important powers for an answerer are 1) the ability to post comments (15pts) and the ability to upvote good questions and other good answers (50pts). So, in the interests of giving as many people as possible the chance to get to that critical level, I will be looking to accept answers from those with less tahn 50 points.


Database Backup

Which statement is used to know the compatibility Level of a database backup file?

(note: you must provide the full, correct command).

backuprestoreadministrationchallengeqotd
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
BradyB avatar image
BradyB answered

RESTORE HEADER ONLY FROM DISK 'D:\Backups\Database.bak'

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.