Koen, I'm not sure we've enough evidence yet to prove this is a bug. It could just be that a different execution plan was compiled after the restart. ...

Did you update your statistics after applying the service pack?

John

No, not quite. That location will only apply to the database specified in the General tab of the Back Up Database Task. If you're backing up all databases...

It sounds as if it should work. We're reaching the edge of my knowledge of this, I'm afraid. Did you run the command I posted earlier just to...

Is this transactional or merge replication? Are you running sp_rename on the publisher or subscriber?

John

It depends on whether your publication is set up to replicate schema changes.

USE PublicationDatabase;

-- Execute one of these depending on whether your replication is transactional or merge

SELECT replicate_ddl FROM sysmergepublications;

SELECT...

What version of SQL Server are you using? Double-click on the Back Up Database Task, and you should find the backup location in the Destination tab.

John

No, backups don't take any locks on tables. There'll be a small IO penalty, but I'd be surprised if you even notice that. The frequency of your backups,...

I'm not sure what you mean. Do you mean delete the maintenance plans, or delete the existing backups? You'd have to remove the maintenance plans yourself. You...

Oooh, that's nasty. I think you need to go into each plan and amend it by hand, I'm afraid. Or take this opportunity to move on to something...

How are you doing your backups at the moment - maintenance plans, Ola Hallengren's solution, or some other method?

John

Is datetime the actual data type of the column? If so, then (quite rightly so) you cannot change the way the value is stored. It's stored as a...

It does for me. Generates a huge long script with lots of sp_addlinkedserver statements (and others). Are you sure you're in Object Explorer Details, not Object Explorer?

John

Yes. Click on Linked Servers in Object Explorer, then go to the Object Explorer Details window. Select all the linked servers, right-click and choose Script Linked Server as.

John

I think some third-party utilities, for example LiteSpeed, allow you to do object-level restores. I've never used that functionality myself, so I don't know how well it suits your...