Simon Smith (12/4/2008)

---

If anyone can tidy everything up and work out why it the error message at the beginning references a database name that doesn`t exists then that would be...

Same with a table variable. Main difference is that...

The only way you can backup a single table is if that table is in a filegroup by itself. Then you can back up the filegroup.

You can backup at the...

and no [] inside the IF, because you're trying to do a string match there, not refer to the DB itself.

What's the code you're trying to run inside sp_MSforeachdb?

Full backups do not break the LSN chain.

Easy to demonstrate

Create database TestingLogs

Go

use TestingLogs

go

Create Table Test (id int)

insert into Test values (1)

go

backup database TestingLogs to disk = 'D:\Develop\TestingFull1.bak' -- full backup...

Three steps backwards....

When data is changed in SQL, the changes are made to the data pages in memory. The record of the change is then written to the transaction log...

Why?

I'll download the video later, watch it and see...

srawant (12/2/2008)

---

Hey Gail,

I have a same database in one of my pre-prod server which is currently dead. I can work on this server to fix the database. So, can you...

Bristolred (12/3/2008)

---

I now realise that this is not the case, as I’ve found out that the log is truncated every time it is backed up. So I don’t understand where...

If the triggers are on the same event, why not just have one trigger that does the work of both?

Just check the version of that management studio, make sure that the patch did successfully patch the client tools.

This particular one's usually the result of...

So where did you set the maintenance plan up from?