I wouldn't count on it.

btw. you can start xEvents to capture deprecated on your current SQL2008R2 instance and preparing for the fix.

ref Track Deprecated Features with Extended-Events[/url] .

...

Andy Warren (12/3/2015)

---

Deep breath Johan! I'm with you on checksum, I just didn't use it for my tiny test backup when I was scripting. I'm a fan of checksum myself....

dndaughtery (12/3/2015)

---

Well, that's not the exact query I'm working on. Scaled it down quite a bit. My query has 80 columns with several case statements etc that returns 1 million...

...It means you have to check the backup before you set the options for the restore. For my revised code & test above you can infer that my backup did...

did you try this ?

Select PrimeKey, Col_A, Col_B, Col_C, Col_D, Col_A_B

from ( Select PrimeKey, A.Col_A, A.Col_B, A.Col_C, A.Col_D, B.Col_A AS Col_A_B,

RANK() Over(Partition BY A.Col_A, A.Col_B, A.Col_C, A.Col_D, order by...

You can do that using e.g. a scheduled task providing that wanted windows account as execution account of that task.

and then have that task execute the wanted sqlcmd using the...

Great feedback, guys ! :w00t:

Thanks.

to use Windows authentication use the parameter -E in stead of the -U and -pwd

ref:https://msdn.microsoft.com/en-us/library/ms162773.aspx

first of all, you only have to install the most recent CU.

First install that CU at the non-active node.

the you will have downtime ! for failing over the SQLinstance from...

Database mirroring in use ?

With regards to Error 18456 I always use Aaron Bertrand's article: Troubleshooting Error 18456

tt-615680 (9/25/2015)

---

Thank you for your help! I’ve tried to run the scrip but unfortatly I get the following error message, I have changed the location name where the transactional log...

Set-location "c:\myfolder\SQLBackups"

# List all files and order by LastWriteTime descending

get-childitem -Filter '*.BAK' | Select FullName, LastWriteTime | sort LastWriteTime -Descending | ft -AutoSize

# only the most recent file

$Bakfile =...

It depends.

What's the recovery model used by the source database ?

What's the final goal of your database ?

Do you need your target database to be in e.g. read-only state, Read-Write...

SET Statistics time, io on

...

Set statistics time, io off

SELECT ...

INTO [TraceMMdd]

FROM ::fn_trace_gettable('E:\Thermo\MSSQL12.MSSQLSERVER\MSSQL\Log\ALZDBA_SQL_Trace_..._20150630_0838_.trc', default)

an off course The Glenn Berry Diagnostic...

To keep the answer brief and firm: No.

The risk encountering...