Ah thanks very much Alzdba. Much appreciated. Derek

Hi Alzdba, forgve me if I'm a bit slow on the uptake here and I do appreciate the best practice as you have stated above. I suppose the nitty gritty...

Hi all, I appreciate the article http://support.microsoft.com/kb/256650 is SQL Server 7 specific. Further down in the article is states : You must make a full database backup after you run...

I waded thru the Micorsoft Knowledge Base and found absolutely nothing even resembling this issue. But at least you have found them. Now you can see them in EM, well...

Would you mind posting your startup parameters ? Also logon to the server with the SQL Server account and using notepad see can you save a txt file to the...

One other thing, are your SQL Server Agent log files being created ?

I am doing some digging to see what I  might come up with as I am curious and might hit the problem myself some day. Just to rule out the...

What happens if your run sp_cycle_errorlog ? Can you or is it safe for you to stop and start SQL Sever ?

Surely your developers are not SysAdmins in the first place. I can understand on a test box perhaps but not on a production box. I have manipulated the TargetServersRole in...

Actually Steve that is a very good idea for a test environment as you can take a performance hit during the opening the database etc. Thanks Derek

Hi, I have the same issue here to a degree. I review the dates the db's were created and use my knowledge of on going projects to try and determine...

Transactional Replication requires a primary key in order to replicate etc. Other method of replicating data which would include tables without primary keys would be Log Shipping. A different topic...

Hi, in the past I use LiteSpeed to backup up large archive databases. Never got the GUI to work mind you, despite talking to their Tech Support. Currently I am evaluating...

If you want to cycle your SQL Server log file - EXEC sp_cycle_errorlog. This has nothing to do with shrinking transaction logs ( ext .ldf ). Stopping and starting SQL...

Hi, back to basics first. Is the log reader and Distribution agents configured correctly. Can you see them under Replication Monitor. Can you see the jobs in SQL Server Agent....