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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Update Statistics

Author  Topic 

vna_mhars
Starting Member

37 Posts

Posted - 2011-02-16 : 21:35:27
Hi,

I Have my database in SQL2000 then I backup the database and restore it to the SQL2005. To improve the performance I do UPdate Statistics. My question is, Can I use the database while the update statistics is running?

Thanks,

Vernold Amodente


vamodente

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-02-17 : 04:57:13
Yes.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -