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 |
|
meridium
Starting Member
1 Post |
 Posted - 2009-10-29 : 05:03:32
|
| Hi,When restoring a SQL 2005 database to another database server, the statistiscs of the source database server are not restored. Is there a way to also restore the statistics of the database?Regards,Meridium. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-10-29 : 07:36:49
|
| You could script them out and then run them on the new database. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-29 : 14:14:33
|
| you should rebuild the indexes after restore to different server |
|
|
|
Pradip
Starting Member
32 Posts |
Posted - 2009-11-02 : 01:46:13
|
| In new server new statistics will be build automatically with improved performance,I think you cannot restore old one.(Why to restore old?)pradipjain |
|
|
|
|
|
|
Restore statistics.