Also check the server startup in configuration manager

Did you checked the physical location?

Ninja's_RGR'us (5/20/2011)

---

GilaMonster (5/20/2011)

---

There is. See the Books item...

GilaMonster (5/20/2011)

---

There is. See the Books item in...

Ninja's_RGR'us (5/20/2011)

---

So the log file is too small and you want him to...

GilaMonster (5/20/2011)

---

It'll help me in making money, I can charge to fix the...

Ninja,

I know you are asking this link for some other(coming) pepoles 🙂

http://www.amazon.com/s/ref=nb_sb_ss_i_0_14?url=search-alias%3Dstripbooks&field-keywords=grant+fritchey&sprefix=grant+fritchey

Thanks perry

sqlnaive (5/20/2011)

---

Thanks Gail. Nice idea. I'll check that out with execution plan and surely post my findings to this post.

Ninja, though i liked your idea, but still will test the...

Check this article's.

Truncating and shrinking the transaction log file

Shrinking log file script

I Hope this will help others.

Edited: to correct the grammar.

Perry,

SQL 2008 32 bit supports Operating system maximum.

Look the default trace in BOL you may get an idea.

Note : It not has each and every changes.

kishorechowdary.erp (5/19/2011)

---

hi,

when i am taking full back full through syntax i get following error:

Msg 3201, Level 16, State 1, Line 1

Cannot open backup device 'D:\test_k.bak'. Operating system error...

Shivrudra (5/12/2011)

---

OS version is :-Windows server 2003 R2 SP2 Ent.edition

I am not getting on :- lock pages memory to the sql account,can you pls describe it more

as when i seen...

You should rather use headeronly option with restore command to check the number of backup files lying in the backup set and then look for backup type 5 which refers...