x

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).

more ▼

asked Oct 10, 2009 at 11:19 AM in Default

RBarryYoung gravatar image

RBarryYoung
782 5 5 8

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Oct 10, 2009 at 04:05 PM

BradyB gravatar image

BradyB
56 1

Excellent, Brady! And now you should have enough points to up-vote other people's questions and answers.
Oct 10, 2009 at 04:30 PM RBarryYoung
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x193
x126
x102
x14
x4

asked: Oct 10, 2009 at 11:19 AM

Seen: 1746 times

Last Updated: Oct 11, 2009 at 05:04 AM