Start Studying!
Add Cards ↓
Deck Info
Description
Tags
Recent Users
Other Decks By This User
- 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
- Restore db/log option:
with DBO_ONLY
- restricts future access to the dbo only
