Hi All,

Thanks for all of your valuable replies,

Here is the server config for those who wanted to know,
Memory 256 GB, 
Processor Intel(R) Xeon(R) CPU E5-2630...

As it seems like there is not a standard approach for this, so have to review all the possible suggestions you guys have recommended, will see how we can manage...

Hi Jeff, you have any articles to support it?

I have tried using resource governor, but whenever the job runs it show the sql server service account in the activity monitor, where as i have another login which i...

Its not the user who creates the view, other users can create the view with that nametype, and that following user needs to have access to those specific name type...

Yeah we tried to copy the files into 15 smaller files,

44 mins video, will listen for sure...

Thanks guys,

Thanks Guys,

I think i got exactly what i needed, i wanted to leave the latest file kept untouched and not delete it, doesnt matter what date the latest file was(1...

Thanks, It would be great if you can give me a reference/documents.

What will be the alternative approach for this, T-Replication? if not Backup/Restore.

Thanks

i want to do mirroring making 2008 as principal and 2008r2 as mirrored. will that work?

This is what exactly i am also facing as mentioned in the below thread

http://ask.sqlservercentral.com/questions/21893/how-can-i-restore-a-database-wo-the-free-space

So, there is no other way to just restore the data without empty file space directly from the backup?

I have the same scenario where i have database bak is 50...

This worked for me as well......

I was able to shrink the initial size of the database as follows

Right click database in Management Studio

Choose Tasks, Shrink, Files

Select File Name to shrink,...