Ronnie

Forcing a checkpoint isn't the same as truncating the transaction log.  A checkpoint is when data from the transaction log is committed to the database.  The transaction log will be...

Sangra

You're right - you do need a primary key on every table you wish to use for replication.  There's no way round that.

Do your tables have any sort of uniqueness...

Lori

Thanks - I think I had come to that unfortunate conclusion.  I say unfortunate because the network people here won't give me a domain account for starting SQL Server and...

a) sp_addarticle, as you say.

b) sp_droppublication (although I've a feeling you have to use sp_dropsubscription first)

c) sp_addpublication (and then sp_addsubscription)

d) if you used @sync_type='none' in sp_addsubscription then you don't need...

Dan

That's the bit I'm not sure of.  I'd say as a minimum you'd have to restart the LogReader Agent after adding the article.  Please try it out - I'd be...

David

The only way you can connect to an instance of SQL Server on a cluster is by using that instance's IP Address or Network Name.  If you try to connect...

Dan

sp_addarticle should be what you are looking for.  The syntax looks daunting, but once you've figured it out, it should be fairly easy to generate a script to add an...

Tony

For constraints, if you know the name of the constraint:

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'constraint_name')...

For indexes:

IF EXISTS (SELECT name FROM sysindexes WHERE name = 'index_name')...

John

In Enterprise Manager, right-click on the database and choose Properties.  Click on the Options tab and you will see the Recovery Model - it will be Full, Bulk-Logged or Simple.

By...

Fintan

Back up your transaction log (assuming you are in Full Recovery mode).  Then restore from your last full backup with no recovery.  Restore all transaction log backups since the last...

It's a cluster server so I imagine it must be Advanced Server.

John

KR

If you're thinking of creating a trigger to roll back transactions, I should think you'd be better off not allowing those transactions to take place in the first place.  And...

Happy to help.

Ian

It's certainly possible to move system database files, and in many instances it's also wise.  For example, you may want your system databases to be on different disks from your...

Ian

Do you have a database called TPM250?  If you do, detach it, move the log file, and then re-attach the database.  Search for "attaching and detaching a database" in Books...