Hi I can't run this at the moment as it's a live prod db,but I'm organising a bak copy to be moved to my test instance. Will let you...

I thought I'd run the checkdb with infomsgs since I'm not getting anything back in the error logs. Does this mean there is a problem or not ? ANd...

The message returned is below, but I needed to use the database_id as some silly sausage used -hypens in the database name which returns a syntax error for the above...

OS is Windows Server 2008 R2 SP1. The only other entries in the sql logs is

-----

SourceMSSQL$SHAREPOINT

CategoryServer

Event3221243525

Computersql.business.local

Message

Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in...

There are no obvious agent jobs which could cause this action. I am stumped and I still need to fix the problem.

The only clues I found where in the event viewer application log for last night. They seem to repeat themselves a few times for couple of different dbs, but...

Vanilla snapshot replication once a night

It's okay I found the settings I needed under right-click of publications and selecting "Configure publishing, subscribers and distribution" and now I've gotten my precious replication working again :w00t:

Thank you for the replies. I will put forward an argument with management that the dbs really need to upgraded to take full advantage of the 2008 functionality, but...

The slipstream solution worked and I was able to complete the install. I have no run into another problem, but I will post this in another thread.

Thanks

Things to consider about going SOLO.

It can be quite lucrative to become a contractor as long as you can keep up with the governemt required bookwork and come to terms...

I agree with Brandie.

I'd mention it clearly once and express my desire to learn new skills. I'd only mention it again once I get the final okay to start...

A cheap alternative is that everyone keeps a diary with the time details mentioned by GSquared and at the end of the week writes a a report and emails it...

Disable the SQL Server login as this is ensures no-one can use the account, but it's still there.

Adonia

Congratulations!

This site deserves the million members. I always come here as my first port of call when I cannot think of a solution to a problem I'm having,...