Actually, I am doing upgrade from 2005 to 2008 SQL server and getting following error.

Wait on the Database Engine Recovery handle failed. Check the SQL Server error log for potential...

This is what I got in the SQLAGENT.OUT file. Do you think if there is any thing related to the mail session ?

2010-08-05 14:50:10 - ? [100] Microsoft SQLServerAgent version...

Actually, Server was set to Windows authentication mode instead of Mixed more. I changed to mixed mode and it's working now.

Thanks for your reply

Ananth... Thanks for the reply.

Actually, I stopped the Restore process on Friday and let Backup and Copy process continue to run. On monday I restarted the restore process and it...

Just confirming, may be I will try that option.

Actually, I wanted to stop the log shipping every month on 1st day for two weeks and then start log shipping...

Alert is setup for every 15 minutes

Backup is setup for every 1 hr

Copy is setup for every 1 hr

Restore is setup for every 1 hr.

I don't see any error in...

Thanks guys,

I setup a Log shipping for testing purpose and getting following message in the alert job but no error in backup and restore job. How to fix it.

The log...

Richard.. You are correct.

Thanks a lot.

and also the schema is on so many filegroups. Here is the example.

CREATE PARTITION SCHEME [PFBTCScheme] AS PARTITION [PFBTCFunction] TO ([FILEGROUP_BTC1], [FILEGROUP_BTC5], [FILEGROUP_BTC9], [FILEGROUP_BTC13], [FILEGROUP_BTC15], [FILEGROUP_BTC16], [FILEGROUP_BTC17], [FILEGROUP_BTC18], [FILEGROUP_BTC19], [FILEGROUP_BTC14])

I assume it is partition because PK indexes are on the schema. here is the example. I think if it is on the schema then it means it is partitioned.

ALTER...

Thanks for your reply.

I know it should grow by little because of the PK index. This table is a partition table and PK indexes are distributed in so many file...

I just checked about the option when I was upgrading to 2008. there is a option called " Launch Upgrade Advisor Analysis Wizard"

when I trying to click that it...

That's all we have to do.. How about integration packages and Analysis cubes

It gave me the error again..

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'GO'.

Msg 111, Level 15, State 1, Line 3

'CREATE VIEW' must be the first statement...

Actually, the issue was not to copy the script and then run it. I know it is working but my goal was to generate the view from the code and...