ALZDBA (7/16/2009)

---

shrinking a log file will not move log data !

A log file can only be shrunk to the last active virtual log !

Hence, you may have to execute the...

Ravi (7/16/2009)

---

Cathy,

We have good information in the BOL regarding this:

Shrinking a log depends on first truncating the log. Log truncation does not reduce the size of a physical log file....

Thank you ravivarma. Do you know why a standard DBCC SHRINKFILE on the log file would have resulted in 48GB if the file could safely be 12GB? I...

I just wanted to post an update. I did shrink the log file and it is now around 48GB. I'll go through our other databases and do the...

Thank you everyone for your responses. My answers to your questions are below:

Type of database:

The database is named qa, but it's a production database on a production box.

Indexing

My index rebuilds...

Hi Krishna. Thank you for your reply.

Krishna Potlakayala (7/15/2009)

---

Cathy DePaolo (7/15/2009)

---

I'm not sure if I should shrink the file or not, because I seem to remember an article...

Jeffrey,

My script doesn't return anything. I suppose I should have set it up to return a code and should put some error handling in place there, so that is...

Thanks Vishal! I didn't end up seeing your reply until just now, with your recommendation. I hadn't refreshed my screen and our mail server has been acting funky...

Thanks to everyone that tried to help me with this one. I did figure out what the problem was. The U drive is a user mapped drive, and...

I do have a proxy and credential. I have other maintenance packages that run just fine in a job. This is the first time that I am trying...

Thank you for reading my post Tim. It was actually your article that I used to get my package developed. Your article was incredibly helpful, but I am...

Thanks rpatil22. I understand now why it failed on the client I was using. That client did not have the internal environment installed.

Would that also cause the problem...

Raviteja,

I think you are looking for something like this:

alter table dbo.test

add testID int identity(1,1) not null

Thanks everyone. Software installation is limited to IT staff in my organization, so I will submit a request to get our x64 servers running the 64-bit version of SQL...

One last thing that I should note is the link to the article I keep referring to. The article describes pre-production tasks and can be found here:

http://www.sqlservercentral.com/articles/Administration/64732/. I...