It really depends on what your database is used for, the 2005 version of SQL Server has some new features like the ability to rebuild indexes online, database mail, database...

Have you considered moving the user daabases another way, such as backup restore or detach attach.

Nick,

We use logshipping for similar purposes, i.e. as an extra backup and also we use for some reporting needs.

Our secondary server is not the same spec as the primary...

Hi Meridith,

The DTS packages in the 'Local Package' folder will be stored in the MSDB database. Several tables in the MSDB database hold information relating to the DTS package but...

Hi Meridth,

Views and stored procedures exist in the database. So if you have a database called northwind with 35 tables 6 views and 10 stoted procs when you envoke a...

Thanks guys much appreciated.

Steve, Thanks for the response, if that is the case could I use log shipping to migrate the database from SQL Server 2000 to SQL Server 2005 in order to...

Also, Are both your servers Enterprise edition of SQL Server 2000?

I have used this white paper by Gathani and found it to be useful and informative. Following the process in this document worked for me.

Do you get an specific errors...

Hans,

When you apply SP1 you get a screen called authenication. On this screen is setting that is set by deafult, that allows you to apply the service pack to all...

You could try Oracle directly, i believe they hold training in Reading. Alternatively Learning tree offer their own training courses on Oracle 10g et al. Not been on any though...

Hi Dave

memory allocation in 2005 is dynamaic by default, I assume you have not cahnged this and you are not using AWE?

some minimal paging is normal. Is the paging you...

2005 handles memory allocation dynamically... This is taken from books online which should reduce your conserns...

The min server memory and max server memory configuration options establish upper and lower...

Also if you are using a native disk restore, and the backup file and the database files are the same disk then the restore time iwll increase.

log_shipping_secondary_databases system table, which can be found in the msdb datbase on the monitoring server it should provide you with the date, time and the name of the last file...