YSLGuru (9/24/2008)

---

I swear I thought I either read about this or had seen it implemented but darned if I can find it now. I often take the results from...

andrew.critelli (9/23/2008)

---

We're running out of disk space and trying to recover some by running the Shrink Database/Log File command. It's not shrinking the log file and only seems to...

James Morrison (9/22/2008)

---

Here is what I found out.

Recovery Model is Full

Database backup is Full ( run at 9 PM)

Transaction Log backups are daily at 12 PM CST

I will work with...

los (9/22/2008)

---

I too am an "accidental/involuntary DBA" facing similar issues as the OP. After considering our company's tolerance for data loss, I decided to go with Simple recovery, daily full...

You should use @path variable for that.

Adi

In this case of course it will not cause fragmentation on your data file. The question is why do you want to shrink the log's size. If you...

Adi Cohn (9/15/2008)

---

You can just disable the job that does the restore to the database. Another option that I sometimes used is to modify the job that does the...

If you want all databases to have log shipping, then you’ll need to setup each and every one of them. Of course you have a choice to use...

You can write a small script with revoke key words in order to revoke permissions on working with an object. You can find more details (very easily) in BOL

Adi...

You can just disable the job that does the restore to the database. Another option that I sometimes used is to modify the job that does the restore. ...

I’m not sure that you’ll get an answer from this forum. You are trying to create a table in Excel and this forum is about SQL Server. You’ll...

I recommend a great article that among other things explains the statuses that each SPID can have. Don’t be alarmed by the article’s size. Most of it is...

You are asking the forum’s readers to do the impossible thing – to help improve performance of a database that we know nothing about. If tuning the database and...

From the way you wrote your question I understand that by successful you mean that at least one row was effected and not that the update statement caused a runtime...

marco.crescini (9/5/2008)

---

He some other informations !!

Update statistics is enabled, and automatics.

Product version is 9.00.3068.00 (workgroup edition).

The o.s. is windows 2003 server SBS 32 bits. 4 mbyte ram

Yesterday I changed...