Hi,

The recovery model for the model database doesn't matter in context of the database itself, but depending what default recovery model you want any newly created databases will be based...

Ooops! Sorry Andrew, too excited.

Hi,

You cannot use SQL Serverr 2000 EE to connect to a SQL Server 2005 instance. To setup your subscription from the SQL Server 2000 (e.g. pull), you will need...

You may want to also consider adding either database mirroring or log shipping to your backup strategy to prevent a similar issue in future.

Thanks,

Phillip Cox

Hi,

Marcus is correct, SQL Server 2005 x64 Standard Edition does not support the "lock pages in memory" configuration setting. You can mimic this by setting Min and Max memory...

Hey,

To help you, more information is required, assuming its still an issue.

Thank you,

Phillip Cox

Hi,

Ok, based on my understanding, you are using SQL Server 2005 x64 Edition on Windows 2003 x64 R2 Standard Edition. As SQL Server has access to all memory and...

Hi,

There are a number of benefits and here is a link outlining the most significant.

http://www.microsoft.com/sql/prodinfo/previousversions/winsvr2003benefits.mspx

Thanks,

Phillip Cox

Hi,

You will need to ensure ports 1433 and 1434 are open on your firewall between servers, otherwise SQL Server will not be able to communicate. In case you have...

Hi Andrew,

No worries, more importantly have you managed to reverse engineer the database?

Thanks,

Phillip

Hi,

If you can see following message in the SQL Server Error Log, then "Lock Pages In Memory" is being utilized, other wise possible mis-configuration of Group Policy for account hosting...

Hi,

Sorry, but I have to double check. Have you copied all db files from CD to your local pc? Have you checked file security properties after copying from...

You may want to also consider your RTO and RPO objectives, as each HA option has different advantages:

1. Log shipping provides backup files as part of process, whereas database mirroring...

Hey,

Have you tried using the built-in diagramming tool, which exist in both versions? In SQL Server 2000 EM and 2005 SSMS, this is under the database name container.

Thank...

Hey,

Long-shot, but have you checked for empty space within file?

Thanks,

Phillip Cox