You might consider running UPDATE STATS on the object after you've run your INDEXDEFRAG.

Stats are only updated automatically as part of a REBUILD operation and are not updated when you...

Perry Whittle (7/31/2008)

---

WIN32_Processor, as i pointed out previously this class returns an instance for each...

Tried looking via Powershell and unless your on Vista or Server 2008, you're not getting anything through the Win32_* classes that WMI exposes. Although, I haven't looked completely through...

Spot on.

FWIW, restoring t-logs from files is really not much different than from a device. You can create a loop to iterate the directory and basically build your restore...

Exactamudno!

An example that backs up t-logs every hour would go as follows:

At 2pm a job would run.

BACKUP LOG FooDB

TO DISK = 'C:\BACKUP\FooDB_20080728_1400.TRN' -- 2PM log backup

WITH INIT

GO

At 3pm the...

IMO, yes, you should be using some type of more reliable staging media and find a way of automating that to tape. I would also suggest that you either...

See here: topic

When you append backups to a file or device, each time the backup runs it checks each of the devices previous backups. So, the more backups you...

Appears to be related to SP2 build 3042 (the "bad" one). Found that the server was reducing backup buffers due to memory pressure. By dropping the MAXTRANSFERSIZE of...

Carl Federl (7/18/2008)

---

I think that you will find that if you compare performing transaction log backups versus a truncate log, then set to full recovery and then a full database...

-r

From BOL under "SQLCMD"....

-r [ 0 | 1 ] msgs to stderr

You can switch between full and bulk_logged without breaking the chain...that's one of the advantages to having bulk_logged as an option (that you can switch back & forth for these...

Ken Simmons (7/17/2008)

---

I just noticed you said for all databases. If you don't mind using an undocumented procedure for sql 2000 this will work.

Create Table #tmp

(dbname varchar(100), RecoveryModel...

Delete files older than N-Days[/url]

Sounds like you took one of Joe Changs classes.... 🙂

The rationalization wrt SAN Cache is that the SQL Server already has a cache (RAM) and is trying to utilize...

I wouldn't use the default administrative (X$) shares for these types of operations. This means that your source server account has[/i] to be in the Administrators group on the...