Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-29 : 07:26:53
|
| Veermallu writes "Can any body please help me that iam using sqlserver 2000 database and in one application iam using a database "tempdb".I want a script so that it will automatically takes the backup every day around 5:00pm.and another script to restore the database whenever i want.please help regardsveeramallu" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-29 : 07:52:01
|
| tempdb is a system database which contains temporary information, and should not be used as a user database. You can never backup or restore tempdb. It is recreated every time you restart the server from the model database. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-29 : 12:31:38
|
| Veermallu, what are you using tempdb for? If you are coding against it, you should stop now for the reason that Andraax gave.Tara |
|
|
|
|
|
|
automatic database backup script