Verify the recovery model of the database. Also, run this query: select * from msdb.dbo.backupset where backup_start_date > '20090602'

Steve Jones - Editor (6/2/2009)

---

Font edited, and pick me up added. You can't "regen" the symm key with the same certificate. It creates a new key, encrypted by the same...

Bob Shaw (6/2/2009)

---

Im trying to perform a transaction log backup to the same *.bak file holding the Full Database Backup. Im getting this error "BACKUP LOG cannot be performed because...

sqlguy (6/2/2009)

---

Thanks a lot for your valuable response.

Regarding backup question when I backup DMK and Certificate and regenerate the symmetric key by using the following scripts the column I was...

Regardless of recovery model, all updates, inserts, and deletes are written first to the transaction log. Which recovery model you use should be based on how much data loss...

Luke L (6/2/2009)

---

Really? I've always wanted to own a bridge, that way I could charges tolls.

But seriously, I...

Yes, you will have to create the database role in each existing user database. You can also create the role in the model database, which should then make that...

No problem. I just thought I might have missed something. Glad to hear that this works for you.

Would it be possible for you to provide more info? ...

I get 4 records back based on your sample data. Please see the code below and let me know what I missed.

CREATE TABLE dbo.Cust ( CID INT IDENTITY(1,1) PRIMARY...

Please don't cross post.

please post replies here.

Please do not post in multiple forums. You will fragment your responses.

Please post replies here.

Please do not post in multiple forums. You will fragment your responses.

Please post replies here.

So it looks like you are running it interactively. You need to review the ENTIRE on screen log. There may be other error messages that may help shed...

Sounds like one of the charater dates isn't a real date, like 2009-02-30. You will need check the data, perhaps running a query on the problem table looking for...