Can you add 'WITH REPLACE' and try it again?

Regardless of whether we can talk you through this restore, you really need to read through the Books Online documentation on backing...

OK, I'll make a guess...

When you mapped the location to copy the files there, you mapped it as your Z: drive. The SQL Server doesn't see it as the...

If you run the following from SSMS while connected to the server:

exec xp_fixeddrives

what do you see? Those are the drives the Sql Server can access and that's where you'll...

Sean Lange (5/15/2015)

---

David Webb-CDS (5/15/2015)

---

Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. ...

Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. You gather the customer,...

Decimal(2) means 2 digits, nothing to the right of the decimal. I think what you want is:

create procedure Test_Decimal

@Protocol_Number numeric,

@Stage1_VO2 decimal(4,2) Output

AS

select @Stage1_VO2 =

case

when @Protocol_Number=1...

There are a couple of cmdlets I found that are very helpful.

Out-Datatable converts a variable into a datatable type

Write-Datatable writes a datatable type variable to a table in SQL Server

I...

This shouldn't prevent your instance from starting. What errors are you getting and what's in the errorlog?

There are a couple of 'gotchas' that I found with this process. There is a limit to how many rows the query will return and if the result set...

If the load isn't one big transaction, maybe you could take the log backups more frequently during the load times. Might buy you better log re-use.

Also, is [Process] a table or a view? If it's a view, please provide the definition.

Backing up the log frees up space within the log for re-use, but it doesn't shrink a log file that has grown to accommodate transaction activity. If the log...

What does this return?

select cast(@int/1000.00 as decimal(9,1))

Dividing by 1000 may be forcing it to do integer math.

In order to help you find the issue, the folks here are going to need to know several things:

Definition of the table you are loading the data into, including any...

Windows swap file?