in addition to above post just one more thing,

before considering the rebuild operation, Do consider the page count as well and then decide is it worth of rebuilding or...

Though the log shipping is pretty straight fwd and you can monitor manually but that will be reactive strategy.

For proactive, microsoft justified it here :-

http://msdn.microsoft.com/en-us/library/ms190224.aspx

Thanks everyone for their valuable input. Was bit confused when someone told me that the feature can be used, but now 100% sure that its not the case.

what does the job history says?

IS IT FRIDAY THE 13TH]:alien:

Log Shipping from 2005 to 2008 should work fine but not in the reverse case

edit:-

my reading mistake , I read windows 2008 as SQL 2008.

Sometime we read what we...

you have more accurate answer here :-

http://www.sqlservercentral.com/questions/Administration/67277/

you can try to move the big tables and indexes in different filegroup.

as long your backup files are safe, you can still restore till your last log backup beginning from full backup.

Do one thing,

rename the database which you restored by mistake...

i will suggest to restart your process from full and then subsequential log in series with norecovery/standby option till you reach the last log backup.

by default users are configured with instance/database specific access as long they do not belong to any group which have the permission across domian(in case of windows login)

if possible, while inserting take the date as varchar and later you can modify your date field to datetime.

Just giving an example on how to convert:-

declare @date varchar(100) =...

Can you try to connect to SSMS using the mentioned id/pwd? You might get the similar error.

If that is the case then connect SSMS with some account which have...

Create new table with same architecture and with your new column.

Then import the data from old table to this new table and dont import the data in once, keep...

If 'EXEC' is the only permission you configured for user then answer is NO.

you can take backup on all your currently running user database and can restore them on 2008 so that you no need to take long downtime for moving your database...