Whats the default the RESTORE statement uses?

If I dont specify a recovery option such as STANDBY, RECOVERY or NORECOVERY, what default option does SQL Server 2008 use?

asked Jul 27 '11 at 02:21 PM in Default

Slick84
1.3k ● 71 ● 102 ● 142

(comments are locked)

2 answers:

It would use RECOVERY, but you can test that.

answered Jul 27 '11 at 02:23 PM

Grant Fritchey ♦♦
62.4k ● 12 ● 20 ● 66

(comments are locked)

Your answer

By Email:

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

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Jul 27 '11 at 02:21 PM

Seen: 327 times

Last Updated: Jul 27 '11 at 02:21 PM