Sql Server 7 - Backups

Front 1

sp_addumpdevice
sp_dropdevice

Back 1

stored procs to add or remove backup devices

Front 2

how do you restore the master db from a backup?

Back 2

you need to start sql server in single user mode:
sqlserver.exe -m

Front 3

filegroup backup functionality

Back 3

need to be toing transaction log backups in order to ever restore a file or filegroup backup

Front 4

differential vs transaction log backups

Back 4

differential backups decrease restore time but increase backup time. Transaction log backups decrease backup time but increase restore time.

Front 5

Restore db/log option:
with stats = [%]

Back 5

displays message every time % of opperation is complete

Front 6

Restore log option:
with stopat = [datetime]

Back 6

restores to specified date and time

Front 7

Restore db/log option:
with restart

Back 7

restarts a restore operation that has been interrupted

Front 8

Restore db option:
with replace

Back 8

create db & files even if they already exist

Front 9

Restore db/log option:
with nounload/load

Back 9

requind/unloads table after restore is dinished. unload is the default

Front 10

Restore db/log option:
with standby = [undo_file_name]

Back 10

specifies undo file name so recovery effects can be undone. Brings up db in read only mode to check between log restores or to act as a warm backup

Front 11

Restore db/log option:
with recovery

Back 11

rolls back uncommitted transactions leaving the db in a state ready for use. the default

Front 12

Restore db/log option:
with norecovery

Back 12

instructs restore operation not to rull back uncommitted transactions

Front 13

Restore db/log option:
with medianame

Back 13

specifies media name for entire backup set. is specified must match name on the backup volumns

Front 14

Restore db/log option:
with file = [file_number]

Back 14

indicates backup set to be restored i.e. 1 = first set on the medium

Front 15

Restore db/log option:
with DBO_ONLY

Back 15

restricts future access to the dbo only