When Gail stated that you should back up to individual files, one of the things this does is makes sure you don't do this:

-- Back up the AdventureWorksDW transaction log

BACKUP...

How often are you backing up the transaction log?

Review the article I link to in my signature about maintaining transaction logs - it will help you understand what you need...

Paul is correct - I get lazy and don't specify the object type all the time.

Neither - use MERGE instead which will do the insert/update in one command.

Glad I could help - thanks for the feedback.

Gary7512 (5/28/2010)

---

Jeffrey, that's a fair question. The backup uses VSS which takes a shadow copy of the drives and works around the issue of locked files. However, I have not...

I am just guessing here, but it would seem to me that DB-B's transactions that were in process at the same time that you have specified would be rolled back....

To check for a temp table, you can do the following:

IF object_id('tempdb..#DeleteUserID') IS NULL

BEGIN

-- your code here

...

hester84 (5/28/2010)

---

When a stored procedure creates a temp table #MyTable, the table name in tempdb is made unique by adding a number, #MyTable_____________________000000004A6

What is the source of that number? ...

Steve Jones - Editor (5/28/2010)

---

Didn't know that they could integrate with SQL to set up for recovery.

The reasons you give are pretty good ones for not using their tool, especially...

Gary7512 (5/28/2010)

---

Jeffery, sorry I probably didn't explain that well. Our db server is a VM on Hyper-V. The Hyper-V host does an incremental backup using Windows Server Backup of everything...

Steve Jones - Editor (5/28/2010)

---

SAN snapshots are good for speed, if you need to quickly debug things. We used to use them to get Customer support people a quick look...

Gary7512 (5/28/2010)

---

Hi Jeffrey. We're using full recovery. We're taking an incremental backup of the entire server every 30 minutes so we can restore from bare metal or just a database...

Gary7512 (5/28/2010)

---

Hi. What can someone do if they don't want a big transaction log? Our db is 7GB and the log is 10GB. There's no way we're going to rollback...

Kevin Landry (5/28/2010)

---

Hi Paul,

I have also considered the Bulk-Logged option, but I do not see how switching to Simple is any more dangerous than using the Bulk-Logged option?

Switching to ANY...