making C1 as identity column helped.

Thanks.

Paresh

I think I hacked it...

CREATE DATABASE AdventureWorks2014_Restored ON

(FILENAME='z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.mdf'),

(FILENAME='z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.ldf'),

(FILENAME='Z:\TEMP\AdventureWorks2014_mod') -- this is actually a folder...

FOR ATTACH

Thnx again Steve:

So you are right, I moved it all to M drive but the database as defined looks for the IMOLTP files in the original location and that...

What is the real size of the "big" database?

Hi Steve

Thanks for the response. Here are the steps:

1. The software my company makes takes a snapshot of db, via Quiescing the db.

2. I then present this snapshot as a...

Hi Andrew

you have a valid point. But how do I mount it to the "original" folder on another server.

So the bottom line is, I have a Virtual Copy Data Management...

Thank you folks for the response.

I have done what Koen suggested.

But the values in the database are very different from the ones in the spreadsheet.

ugh.

Cheers

Paresh

let's just say there is GB. How would you then handle it?

As I alluded before, I have the same exact modules for MB, KB, TB and bytes.

Once I have answer...

I have similar modules.

Once I have response for this, I can substitute it in the other places.

Thanks for the quick response.

Paresh

Thanks Grant!!!

Hi SSCommitted,

I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.

Citing this as one of the advantages.

Paresh

I am just running a bench marking test. With and without columnstore indexes....

Thanks mate....I just did that and it worked.

it was one of them SSRS "Duh" moments.

The report shows up in the "detail view" not on tile view, go figure.

So I was able to save that report and upload...

thanks so I am pretty much stuck.

I followed advise on the link, it took me to the same screen I was before.

We got fresh media from MS. that has a...