Hi,

Couple questions:

1. What service pack level do you have on SQL 2K and SQL 2K5?

2. What protocols are enabled on the SQL 2K5 server

Thanks,

Phillip Cox

MCITP - Database Administrator

Unable to see error message.

Please explain the error you are receiving and direction of linked server you are trying to configure.

Thanks,

Phillip Cox

MCITP - Database Administrator

Hi,

When executing via QA, it will work as the program name is set to "Microsoft SQL Server Mangement Studio - Query", but when running from SQL Server Agent the program...

Hi,

Able to reproduce error and just performing some analysis and will update you shortly.

Thanks,

Phillip Cox

MCITP - Database Administrator

Hi,

You will need to use servername\instance name to connect (e.g. MyServer\MyInstance).

Cheers,

Phillip Cox

MCITP - Database Administrator

Hi Am,

Table paritioning and storage are two different, but related concepts. As you will know, partioning a table is logically slicing your data for improved data access performance and...

Hi Richard,

Have you considered archiving to a seperate archive database as possible workaround? Any reason why plan is to archive within same databae?

Thanks,

Phillip Cox

Hi,

Have database(s) been upgraded from SQL Server 2000 or native to SQL Server 2005?

Is this the first time running CheckDB on impacted database(s)?

Does tempdb live with database files?...

Hey Stanislas,

Thanks for information and as suspected, I/O (e.g. tempdb size and Raid) is likely candidate. In addition, the number of disk in array is probably low in comparision...

Hey,

Ok, we'll try a few quick tests to see if we can uncover the root cause.

First, please run the following command and post results. In addition, please let me...

Hi,

Impact of removing this group is your system administrators will not be able to access SQL Server and possbily the service accounts. Please have a read of following document...

Hi Sean,

Thanks for update and sorry suggested test didn't solve problem.

I am still looking into this and just wanted to know the size of the database you are checking? ...

Hi Sean,

Ok, look forward to update.

Thanks,

Phillip Cox

Hey,

This may be due to new data purity checks that SQL Server 2005 automatically performs for databases created within SQL Server 2005. If you created your databases using this...

Hey,

I would suggest you try to restore using the verifyonly option to make sure the backup set is valid.

RESTORE VERIFYONLY

FROM DISK = ???????????????

Let me know results.

Thanks,

Phillip Cox