Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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
|