Michael Valentine Jones (1/28/2009)

---

Matt Miller (1/28/2009)

---

Michael Valentine Jones (1/27/2009)

---

Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones by 50...

probably more...

CozyRoc,

I am not a happy bunny. Got this to work (eventually) only to find this in BOL after I was unable to logon with SQL ids on the destination server:

At...

Michael Valentine Jones (1/27/2009)

---

Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones by 50 yards wide)

select Football_Fields_per_Million_SQ_Ft =

1000000/(select SQ_Ft_Per_Football_Field...

you gotta love SQL coders!

Michael came up with the acreage, Matt the football fields, so half a shirt each.

Unfortunately for them I am totally unable to deliver on that promise....

first shirt to whoever can tell us how many acres 1 mm sq ft is? and so we can picture it how many football fields that is.

Can I have my...

log shipping is not sensitive to service packs, you wont need to break it and re-install.

apply the service pack to the primary first, no technical reason for this, but it...

thanks for the reply. Please bear with me -

I've gone for option one but have hit the following problems:

I set protection level at encryptsensitivewithpassword and set a password, although...

this URL appears to have a link to the code -

http://www.sqlmag.com/Article/ArticleID/15804/sql_server_15804.html

any problems give me a shout I can send you everything needed to set it up.

Note - the srticle...

I use a log shipping set up supplied with the BORK (back office resource kit), its written by MS employees, uses SQL Agent jobs and sqlmaint and works extremely well...

in ssms in the options tab you can overwrite the locations to the directories you want to restore to. This is equivalent to using the 'with move' option.

the first...

if its only the log you want to shrink use the shrinkfile command instead. for just the log file.

s this statistics database updated? if so even in simple mode it...

no probs,

Gail, thanks for pointing this out, I've covered it with the OP (see previous posts) and I think we have one more DBA educated in the pitfalls of shrinking files....

good news. auto shrink (and shrink in general) is not without its uses, thats why its there, but is dangerous if not used with care! 🙂