Hi Gail,

Could you please tell me how to delete statistics referenced in the error messages and this should be done in production SQL 2000 instance or SQL 2005?

Thanks

Thanks Gail,

Here is the scenario: Source server is a production SQL Server 2000 Standard edition and Destination is SQL server 2005 developer edition. from the production we are taking the...

Thank you

In serverB, sql server 2005:

DBCC CHECKDB(Mydb) with no_infomsgs has no errors.

DBCC CHECKDB(Mydb2) with no_infomsgs has below errors

Result:

Msg 2508, Level 16, State 3, Line 1

The In-row data RSVD page...

Could you please advice me on this.....I found and one link http://www.jhsupport.se/download/SBS_2003_R2_Upgrading_the_Sharepoint_instance_to_SQL_2005.pdf (page # 24) in which default collation settings were chosen.

Thanks

Thanks Sunny..

I followed the steps you suggested and its working perfect!!

I have one more question.. In Operator properties->Notifications there are 2 radio buttons

1.Alerts

2.Jobs

By default Alterts is selected. Here do I...

hi,

In official white paper from Microsoft commited by Bill Baer’s , Database Maintenance for SharePoint (

http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409) it's stated that:

For many situations the default server-wide fill factor level of 0 is...

hi,

Therefore, in a cluster where all three servers have 16GB, you would need to do something like this:

OS/Other Apps: 4GB

Instance 1: 4GB

Instance 2: 3GB

Instance 3: 3GB

Instance 4: 2GB

Total: 16GB

The way...

Thanks Collin,

We have the page file size as 2046MB, we did not increased its size so far.On node 1,we set the max memory as 12 GB and left 4GB for...

Hi,

Could you please anybody working on maintaing share point databases in SQL Server 2005 ,advice me how to maintain the databases considering creating multiple secondary data and log files for...

Hi,

For the instance on node1, we set the max memory as 12 Gb out 16Gb and now everything is fine. But after a week Iam seeing the message free virtual...

Thank you Rangel,

So far We did not get any issue with the collation settings but my concern is not to get any problem in future. As you are maintaining the...

could you please give me some guidelines on setting this Min and Max values for multiple instances on one node

plz advice me

LA,CA USA

As BOL says that to change the collation, first take the backups of current system dbs(with collation x) and rebuild the system dbs with the new collation(y) and restore the...

Hi,

From the link http://technet.microsoft.com/en-us/library/cc263187.aspx#section4

'SQL Server and database collation

The SQL Server collation must be configured for case-insensitive. The SQL Server database collation must be configured for case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive....