Had an alert fire telling me the temdb was full and to run a backup on it. W
hen I tried it gave me the following error:
MIcrosoft SQL_DMO (ODBC SQLSTATE: 42000)
Backup and Restore operations are not allowed on database tempdb, BACKUP DAT
ABASE is terminating abnormally.
HELP!Why would you want to back up tempdb?
http://www.aspfaq.com/2446
http://www.aspfaq.com/2471
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Robert" <rsalazar@.cbbank.com> wrote in message
news:2D5A012C-C61B-4985-B609-D6DB8E8F4D08@.microsoft.com...
> Had an alert fire telling me the temdb was full and to run a backup on it.
> When I tried it gave me the following error:
> MIcrosoft SQL_DMO (ODBC SQLSTATE: 42000)
> Backup and Restore operations are not allowed on database tempdb, BACKUP
> DATABASE is terminating abnormally.
> HELP!
>|||Thanks, read the alert wrong. Hey, Im a newbie. Ran the TRUNCATE SCRIPT, all
is well
-- Aaron Bertrand [MVP] wrote: --
Why would you want to back up tempdb?
http://www.aspfaq.com/2446
http://www.aspfaq.com/2471
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Robert" <rsalazar@.cbbank.com> wrote in message
news:2D5A012C-C61B-4985-B609-D6DB8E8F4D08@.microsoft.com...
> Had an alert fire telling me the temdb was full and to run a backup on it.
> When I tried it gave me the following error:
> Backup and Restore operations are not allowed on database tempdb, BACKUP
> DATABASE is terminating abnormally.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment