Jeff Moden (2/14/2009)

---

Thanks, Brian. My short term memory is pretty well shot... correct me if I'm wrong, please... you weren't one of the folks that came up and introduced...

Brian Karcher

I'm the IT Manager at Progessive Metal.

Jeff, I hear a non-RBAR solution coming... anyway, thanks for the awesome presentation last night at the SEMSUG at Microsoft!

I had a RBAR "discussion" with a...

Double-check the Windows event logs on both servers. How long did you specify to keep the trn files? I'd check permissions on the shared log shipping folder, as well as...

IMHO... and for future reference:

[soapbox]

I suggest avoiding any and all 3rd party backup tools for any and all versions of SQL Server. The native backup methods are the...

select convert(varchar(30),cast(MyLongDateField as datetime),101) from MyTable

Yes, you should be able to...but try it out.

In fact, the date doesn't even need to be fully formatted:

select convert(varchar(30),cast('Oct 2 08' as datetime),101)

Just use the normal cast, then modify the datetime to fit whatever format you need:

select cast('October 02 2008' as datetime)

The full command is:

select convert(varchar(30),cast('October 02 2008' as datetime),101)

Thanks... so far these suggestions match my thoughts pretty well. In general, and especially on smaller systems, I leave tempdb alone. I don't set a max size limit on...

It seems like you are starting in the right place. For larger databases, I would also suggest looking at the location of your mdf/ldf files, tempdb size/location, and disk configuration...

Leaving a MS server alone for a year? There's your problem... 😀

In any...

Yes...just take your script above and make 2 copies. Set one to run on...

So test (12 hrs) is nearly three times as slow as production (4-5 hrs). What issue are you tyring to address?

I think you've answered your own question... But in any case, I'd separate this out into 2 batches: run the smaller tables first, then the big tables. I'd run...

I'd suggest using the "Transfer Jobs Task" in SSIS.