Vertigo44 (1/18/2011)

---

As fate would have it most of the SQL servers I have inherited have been configured to write the backups on the same local disk that the databases reside...

Dj463 (1/11/2011)

---

Hello all,

I am currently taken full backups of a database daily. For some auditing purpose i need all the transactions that happen in that database. So if i copy...

anonymous.surfer07 (1/14/2011)

---

mmm.. someone said to me that we can restore our database without backing up that database first...

This is scenario he told to me :

First : create new table.. for...

For us, any VLDB that is critical has some kind of high-availalbility option like mirroring or active-passive clustering to help stave off outages. However, no solution is perfect.

What we have...

KenpoDBA (1/6/2011)

---

Yeah, I understand that, but it's not a good idea to allow business users to backup DBs to begin with. They put backups in odd locations and fill...

KenpoDBA (1/5/2011)

---

Thanks Jeffrey...

however in the scenario you described, doing a native SQL backup and putting it into an agent job is still the best solution. All you have to...

KenpoDBA (1/5/2011)

---

I can't think of any real honest business case where taking backups outside of native SQL is necessary. I hate it when people choose to show the coolness...

Jimmy,

Have you found a method to provide percent completed with a PowerShell script? We use P$ to run ad hoc backups, but the most frustrating part is that there is...

Oft times I find that the Internet is a reminder of items that I don't know. However, I am glad that there is a community of users that can share...

In case anyone else sees something related to this, but is a non-yielding process it is addressed in SQL 2008 R2 with CU3 http://support.microsoft.com/kb/2261464/

and in SQL 2008 SP1 in CU4...

Mr. Andersen (10/20/2010)

---

I finally had time to go back to this issue and had a chance to run the script you suggested. I tried running the script immediately after the...

Jason,

I have used this to great effect! However, rather than use it as a stored proc, I just run the query to get the information.

I'm sure you're asking why. Mainly...

Yes, that will show you what is running for the SPID, but it does not show you the rest of the information like SP_WHO2 does. This adds the inputbuffer...

Jon.Morisi (10/4/2010)

---

Hi,

I've been operating with the preference to take SQL server offline when defragmenting the disks in which SQL Server datafiles or logfiles reside on in order to avoid possible...

Mr. Andersen (10/5/2010)

---

Jeffrey Irish, I agree with you that under normal circumstances resource shortage will slow down performance and use up a lot of CPU power. My primary concern is...