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 |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2008-08-28 : 00:14:54
|
| Hi Experts, What are all happens when we restart SQL Server?Will the indexes gets rebuild during startup?TIARKNAIR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 00:36:50
|
| Indexes do not get rebuilt at startup. At startup, various things happen but the most important thing is that uncompleted transactions are rolled back and completed transactions are rolled forward. This gives us a consistent database at startup.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Aequitas
Starting Member
8 Posts |
Posted - 2008-08-28 : 12:53:30
|
| Hello,I am recieving a DLL error after a server restart. Now my full text indexes are corrupt. When I try to rebuild them, they go throught the natural build process, but no data populates to them. Any thoughts? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Aequitas
Starting Member
8 Posts |
Posted - 2008-08-28 : 12:59:17
|
| My apologies. A little new to this. |
|
|
|
|
|
|
Server Restart