The answer is no, you cannot drop or backup the temp db. However you can increase or decrees the size.
open ssms run the following script.
backup database [tempdb]
to disk = 'C:\tempdb.bak' with stats = 10
it will return the error message
Msg 3147, Level 16, State 3, Line 1
Backup and restore operations are not allowed on database tempdb.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
open ssms run the following script.
backup database [tempdb]
to disk = 'C:\tempdb.bak' with stats = 10
it will return the error message
Msg 3147, Level 16, State 3, Line 1
Backup and restore operations are not allowed on database tempdb.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
No comments:
Post a Comment