824 errors are indications that you have a problem with your IO subsystem. You need to work with your server and SAN team to identify why you are getting...

Why are you trying to split up the processing? SQL Server will take care of that for you using parallelism. If that isn't working fast enough, post the...

As long as there are no 2008 features in the database - then you should be able to do this. You would first use SQL Compare to build the...

Those errors are not related to SQL Server - rather, they are errors with your IO system and will eventually cause corruption in your databases.

You need to call MS support,...

Well, that depends on the table. Sounds like this table is the most active table in the database - but you would know better than I 😉

Remember, there could...

smesser (3/14/2010)

---

Having thought some more about your suggestion while I am sure they are good suggestions I don't think they can account for our problems other than the reusing the...

Here is the link to the 2008 documentation: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/html/309b9dac-0b3a-4617-85ef-c4519ce9d014.htm#Configure_services

You'll note that it states the following:

After the table of services and startup types. You...

iamthemanx (3/14/2010)

---

That's interesting, never thought on check the script(s) behind.

I know for sure is a security stuff, the way SSMS2008 is reading that from the SQL2005 instance. But why...

smesser (3/13/2010)

---

I will look into changing the autogrow configuration.

I am not familiar with instant initialization so I will have to look that up.

The table has two indexes (both Non-Unique, Non-Clustered):...

If you are allowing your database to autogrow - that would definitely be an issue. You should manually grow the file out, monitor and grow it manually as needed.

You...

You need to stop one of the processes here - you are causing problems with the backup chain and won't be able to restore the system when you need to.

Differential...

Yes, the services must be set to manual so cluster adminstrator can manage stopping and starting the services. That's what it is supposed to do - because on a...

You can create a SYNONYM for that object - as in:

CREATE SYNONYM dbo.MyTableName FOR [linked server].db.dbo.TableName;

Then, in your code you reference your synonym:

SELECT {columns} FROM dbo.MyTableName;

If the linked server changes,...

I would verify that your new user account for the agent was added to the right local windows groups. There is a specific group for the Agent and that...

To add to what Gail posted - the term ONLINE for index rebuild has nothing to do with whether or not the database is online. It means that the...