Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/15

Click to flip

15 Cards in this Set

  • Front
  • Back
sp_addumpdevice
sp_dropdevice
stored procs to add or remove backup devices
how do you restore the master db from a backup?
you need to start sql server in single user mode:
sqlserver.exe -m
filegroup backup functionality
need to be toing transaction log backups in order to ever restore a file or filegroup backup
differential vs transaction log backups
differential backups decrease restore time but increase backup time. Transaction log backups decrease backup time but increase restore time.
Restore db/log option:
with stats = [%]
displays message every time % of opperation is complete
Restore log option:
with stopat = [datetime]
restores to specified date and time
Restore db/log option:
with restart
restarts a restore operation that has been interrupted
Restore db option:
with replace
create db & files even if they already exist
Restore db/log option:
with nounload/load
requind/unloads table after restore is dinished. unload is the default
Restore db/log option:
with standby = [undo_file_name]
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
Restore db/log option:
with recovery
rolls back uncommitted transactions leaving the db in a state ready for use. the default
Restore db/log option:
with norecovery
instructs restore operation not to rull back uncommitted transactions
Restore db/log option:
with medianame
specifies media name for entire backup set. is specified must match name on the backup volumns
Restore db/log option:
with file = [file_number]
indicates backup set to be restored i.e. 1 = first set on the medium
Restore db/log option:
with DBO_ONLY
restricts future access to the dbo only