Index maintenance cause pages to flush out,  so if you have index maintenance jobs scheduled it could be the one of reasons other then described above.

I usually take database offline before restore as some apps/services keep on connecting to database. 

-- run against database which you want to take offline
declare @getdbid int...

thanks guys

it didn't work, probably something to do with collation, I am on SQL_Latin1_General_CP1_CI_AS

print CONVERT(VARCHAR(3), ASCII('=')) + ' = ' + CHAR(240)

print CONVERT(VARCHAR(3), ASCII(N'=')) + ' =...

another way of doing backup for all databases, I use this for SQL express backup via sqlcmd/task schedular, BTW you can use SQL agent from standard/developer/enterprise edition to take backup...

you might want to do sys.configurations comparison before you call Apple.

I am not aware of cross-compatibility issues but you may want to try that , but I doubt there will be any cross-compatibility issues with SQL 2016,  and Yes ,...

Never mind I found the correct syntax

USE [msdb]
GO

/****** Object: Alert [Alert High CPU % (WMI)]  Script Date: 12/6/2017 1:38:57 PM ******/
EXEC msdb.dbo.sp_add_alert @name=N'Alert...

make sure you use FQDN for listener e.g. listener_name.domain.com when use ping or for connection.

That is one way of doing it,  you could use replication [snapshot?]  or   use import export wizard

lol, my day is just fine, I wish very good day for you too

Well I guess, I mentioned in my earlier post executing handle should be the second step, it should execute only if the 1st step (recycle) fails,  I still think it...

just for clarity see the example below, my apologies in advance for not mentioning the correct filename again .

 Handle.exe -a C:\Path\To\Resource\That\Is\Locked\Open > Output.txt

I may be wrong but my understanding is that process explorer is graphical tool, you probably need to use  keyboard shortcut Ctrl+F. or click the “Find” menu and select “Find...

thanks, it is readable now