Steve Jones - Editor (4/27/2009)

---

Sounds like connectivity issues.

If you remote to the server with this account, does a local SSMS install run better? Have you tried another workstation with your...

I was hoping to find something that had a...

Found two procedures that work...

sp_server_info

and

master..xp_msver

GSquared (2/10/2009)

---

If the point-in-time selected is in log file 5, then yeah, it would be usual. It finishes at that point, and doesn't need to go any further, so...

GSquared (2/10/2009)

---

There are backup history tables in msdb that you can use to build an automatic PIT restore script. Since they have the backup time in them, as well...

tosscrosby (1/27/2009)

---

And just to add to your reading pleasure, Paul Randal wrote this article. It may give you a little better understanding of recovery. Not necessarily what is right for...

DavidB (1/27/2009)

---

Lee - Hopefully my interjections aren't causing confusion in conjunction with Gail's comments. If so, go with hers. 🙂

The tape backup situation should not be an issue. I'm...

GilaMonster (1/27/2009)

---

Something like that.

One folder per database, and both database and log backups get time stamps. So, for 2 databases, I'd have something like this:

DB1\DB1_Full_20090101.bak

DB1\DB1_200901010800.trn

DB1\DB1_200901010815.trn

DB1\DB1_200901010830.trn

DB1\DB1_200901010845.trn

DB1\DB1_200901010900.trn

DB1\DB1_200901010915.trn

DB1\DB1_200901010930.trn

DB2\DB2_Full_20080101.bak

DB2\DB2_200901010800.trn

DB2\DB2_200901010815.trn

DB2\DB2_200901010830.trn

DB2\DB2_200901010845.trn

DB2\DB2_200901010900.trn

DB2\DB2_200901010915.trn

DB2\DB2_200901010930.trn

Now the maintenance plan can do...

DavidB (1/27/2009)

---

Lee - Steve just wrote an editorial on this with some associated discussion that can be found here http://www.sqlservercentral.com/articles/Editorial/65492/ It would certainly be worthwhile to read that and some...

GilaMonster (1/27/2009)

---

No...

I have a question for the OP...

I had an issue with detaching a database in SQL 2005 SP 2 STD edition...

I had a post about it here on S.C.C.

http://www.sqlservercentral.com/Forums/Topic628227-146-1.aspx

Which another...

steve smith (1/6/2009)

---

This may sound like a weird question, but why didn't you simply take a full backup of the database, zip up the backup, and ship the (encrypted) zipped...

Thanks for verifying this MANU. I would assume there is some sort of logic behind this behavior and I am just not seeing the "Advantage" of stripping out the...

Thanks for the reply Gail...I guess I was trying to set up a scenario that you needed to recover from completely...

I think I tainted my own test by having the...

Hi Gail,

Thanks for the reply and I did fix my first post, my bad!

Anyways...let me expand a little bit. Lets say that either the server crashes...you loose a C:\...