Not-worker??? Auuugh, run..now! 😉

First question(s), are you using advanced file types on the Networker backup server? If so, what are they made of and how many? ...

SIMPLE recovery model only allows you to recover back to your last full backup. You cannot recover individual transaction operations from a database in SIMPLE mode. You need...

I've got a restore generator script[/url] that will generate a restore (with move) statements. See the section "-- Change these variables:" in the script for the examples.

This will only...

Forfiles is not included in every os by default. I needed to make sure that the code was supportable with no additional external software requirements (resource kit executables and...

Use this all the time....

SET NOCOUNT ON

GO

SELECT Command

, 'EstimatedEndTime' = CONVERT(varchar(26),Dateadd(ms,estimated_completion_time,Getdate()),100)

, 'EstimatedSecondsToEnd' = CONVERT(decimal(9,2),(estimated_completion_time * .001))

, 'EstimatedMinutesToEnd' = CONVERT(decimal(9,2),(estimated_completion_time * .001 / 60))

, 'OperationStartTime' = CONVERT(varchar(26),start_time,100)

, 'PercentComplete' = percent_complete

FROM sys.dm_exec_requests

WHERE...

Bear in mind, that the default trace rolls over at 20MB. It's quite possible that there has been enough activity that the information has 'aged out' of the default...

I just submitted a script that will do exactly what you need...it generates a restore script but can easily be modified to execute it instead. You'll need to wait...

You want either osql or SQLCMD and the -Q option for either.

BCP will only execute a query for bulk loading or unloading tables.

Generally in a migration, you don't move the system databases (except for MSDB). You move everything but the master, model & tempdb. If you've already built the new...

You want your system databases on the SAN as you do the user databases - especially if you plan to turn this system into a cluster at some point later...

More than likely, what's going on is an ONLINE DBCC operation creates a snapshot sparse file for it's operations - this file now becomes part of the database filestructure temporarily...

I'm willing to bet (at this point after researching enough) that we're just looking at it too deeply...as my wife is fond of telling me "Stop thinking". 😉

IMO, there's enough...

Understood, but I can see how one might wonder if instant file initialization makes use of sparse files...

I went digging through BOL yesterday after wondering the same thing....

Are you backing up to a device or individual t-log files?

If you're backing up to a device, the lookups on the device that initially occur in the backup process can...