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-08 : 07:15:56
|
| Hitsi writes "Why the performance of my sql server version 7 running on NT4 service pack 6 database increasesif I backup the datanbase & restore the same again? Have u also observed the same?Thanks in advance" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-08 : 12:17:11
|
| I have never experienced this. Why are you backing up a database and then restoring it in the first place? Is it production?Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-08 : 13:18:52
|
| Maybe because the SPs are getting recompiled?Because the tr log is being cleared?A checkpoint is releasing memory?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Shastryv
Posting Yak Master
145 Posts |
|
|
|
|
|
sql server 7 performance increases on backup restore!