Yes, I did, but I moved the backup files from the USB external hard drive onto local disk to remove one variable in the restoring database process.

The restore...

Oh, ok! Thanks for the info!

I'm doing some research on what exactly BACKUPTHREAD and BACKUPIO exactly means and I've read that it doesn't exactly mean that it...

Oh wow, that DBA bunch price is very good compared to just LiteSpeed's license. I'm completely drooling over the virtual restore (since I'm wishing that I have that right...

Grant:

No, I haven't checked that the disks are properly aligned. I haven't yet finished reading the white paper. I did try to execute a command to check, but...

Also, I've seen spikes of Avg Disk Queue Length of 70+ on the disks where the database files is being restored on.

73 minutes has passed and it is...

Thank you.

I have queried the sys.dm_os_waiting_tasks using the SPID and the wait types are (1) BACKUPTHREAD and (10) BACKUPIO. I guess that means that there isn't enough I/O throughput...

Thank you. Do she have an account on here where I can attempt to contact her?

Unfortunately, we do not have a SAN. However, we are looking...

Thank you for the response.

Yes, the Disk Queue Length is very large on the disks that have the backup files and the disks where the database files are...

Thank you...

Oh whoa! Thank you so much! I really appreciate it!! 😀

Thank you! But how do I use the Performance Monitor to create a numerical baseline? Do I just go through the graph and just manually average it out?...

Thank you so much!! It works!! :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:

Yeah... I don't understand what I'm doing wrong. I declared the variable in the SSIS menu --> Variables and I set the variable1 to hold the expression... ...

Thank you for your suggestions! I'm trying the expression method and I have 2 variables within the expression.

@[user::variable1] = "update email set locator_id = ee.locator_id from electronic...

Hehehe! Thank you very much for all of your help and input! I will begin the XML configuration files since I agree that environment variables will confuse people....