you can use powershell to backup the SSAS database.

import-module sqlps

Backup-ASDatabase -BackupFile "c:\backup\ssasdb.adf" -Server MyServer -Name MyDatabase -AllowCompression

you could then just schedule the powershell script with windows task scheduler.

Does the file c:\test.csv exist on the sql server or is this file on your local computer? Bulk insert is looking on the SQL Server's C: drive.

Robert klimes (10/29/2014)

you could dynamically create calendar table with recursive cte but I am not sure it would scale well on a large...

you could dynamically create calendar table with recursive cte but I am not sure it would scale well on a large data set.

...

It makes it very difficult to help without schema info, sample data, and expected results. read the link in my signature and post more info if the following does not...

The message states you need at least SP1 for windows 7 and your system config screen shot shows that you do not have SP1 installed.

http://windows.microsoft.com/en-CA/windows7/install-windows-7-service-pack-1

Awesome!:-) Thanks alot, this definitely gives me something to work with.

the xml you posted is from the lock_deadlock event. you need the xml from the xml_deadlock_report event.

That may be a good thing that it is enterprise as there are some Sharepoint features require it.

As for what s creating these snapshots, i don't believe this is something...

do you want to double check your edition

select SERVERPROPERTY('edition')

You are correct that database snapshots are enterprise only.

DBCC checkdb does take a database snapshot but the file is hidden (not hidden in 2014, but does not have .snap extension)

you...

At the top of the xml there are tags <victim-list>. here is an example

<victim-list>

<victimProcess id="process207c1d468"...

You could view it in the GUI. Go to management->extended events->session->Deadlock. right-click on package0.event_file and choose "View Target Data"

here is a basic query. I am sure someone will add something...

I think where you are getting a difference is when you are loading the CTE for your source.

run the following on both servers and check if you get the...

First, Hardware is not identical, server 1 has twice as much memory as server two.

Second, the plans you provided use different values for the parameters.

good plan: [@dtImportOrder]= '2014-10-01 14:56:58.380'

...