I think you need to restore only up to just before you deleted the table. If you restore the entire log, then you'll re-delete the table that you just restored....

Yes, it is done quite a bit. I've just inherited some databases that have the ID field in the 2 different formats in various tables ..... screwy. The 2nd...

xyzt (10/31/2008)

---

Very good article. Can you explain what occasionally happens in my environment.

Full Recovery mode, SQL 2005

db full backup each evening

Transaction log backup at noon and 6...

David Swanson (10/31/2008)

---

Disclaimer: I work at Quest as the PM fro LiteSpeed so you probably have a good idea about what I might recommend.;)

That being said, LiteSpeed's Object Level Recovery...

tosscrosby (10/31/2008)

---

Just my 2 cents - either the Idera or RedGate product (I want to say Idera but the memory isn't what it used to be!) did not require a...

Why do you want to delete backup history ? It doesn't take up that much space.

It can be useful to:

- Identify when an old backup was taken in...

Hmmm, must be something funky in the maint Plan. You actually see My_DB_20081029_0600.TRN type files on your system ?? Are they 0 bytes ? Is...

jay holovacs (10/30/2008)

---

Our current backup strategy is backing up various databases to a specific directory using SQL. The directory is then backed to tape every night. Some full, some simple...

Have...

I run this. You can change the WHERE clause to limit the # of days or specify a specific database. It's useful for double checking that everything's getting backed up...

Sr SQL developer (10/29/2008)

---

I also had tested restoring individual tables using LiteSpeed. The original client database was 1.2 TB and the process required nearly as much time as restoring the...

The error is when you try to open the package to edit it ?

When was the last time it worked ?

What version of SQL, SP# ?

Does it affect all packages...

Transactional replication might be a better solution to keep tables in 2 databases in sync.

Are you using SQL 2005 on your desktop to manage your 2000 server ? I remember some kind of problem with some DTS packages, and they were ok with...

Not sure why I'm bothering to post again ..... but here goes. As a DBA, the main job is to protect the data, just as you might protect...