I take it you are using the native logshipping in 2005.

The wizzard should have allowed you take a backup the database and copy to the secondary server.

I also...

Found the answer to my own question...

http://download.microsoft.com/download/2/d/f/2df66c0c-fff2-4f2e-b739-bf4581cee533/SQLServer%202008CompareEnterpriseStandard.pdf

It appears the encryption will be limted in standard edition (not sure what that means) and is of course subject to...

I was at the launch event but i have not been able to download the slides either...Although i have not checked for a while. There was a URL in one...

Does the readonly login have access to the underlying database? The fact it works with sa leads me to beleieve that the user needs some further permission at db level...

Restoring from your backup is proably the easiest. You can then script the restore and schedule it in a job. So it will run automatically.

Re query with master. You...

When clustering the data i.e the database files for both the system and users database will need to stored on a shared drives managed by the cluster. so when you...

Hi Martin,

Thanks for the response. I wasn't going to delete the directory structure under any circumstances. I'm not overly keen on deleting any files from it either. Just wanted confirmation....

This link may help too...

http://technet.microsoft.com/en-us/library/ms189431.aspx

I'm not sure if this will work... but when you process the cube I beleive the default setting is 'process full' I think there is also a setting for 'process...

Is the SQL Service running?

Its possible for the database to be in the middle of transaction when the server restarts.

All actions of a single transaction are logged to the log file but to...

I suppoes the question is...How do your clients feel about that situation.

This link may shed some light on your DTS migration

http://www.sqlservercentral.com/articles/Design/migratingdatawarehousesystemstosqlserver2005/2501/

It really depends what your DTS packages do but this article will help.

Do you have a backup, restoring maybe may be your only alternative.

You could script out the select statement on the table using management studio and then add the CREATE VIEW View_Name AS statement and reference to the tables in the...