Help with SQL Server 2008 R2 (basic request)

[tripex]

Hey guys,

It's been a looong time i've touched anything related to SQL

So a relatively simple task has been dumped upon me

I need your halp!

Situation:

I need to restore a backup of database A (production) into existing database B (used for tests and such)

OR if the above proves to be complex:
I need to restore the backup of database A into a new database called C.


What i have:

The backup i mention consists of two files MDF and LDF (belonging to database A) that were zipped directly from source (late at night, no one was using the system) a couple of days ago by BackupAssist. This is not a SQL backup. This is a Files backup in ZIP format.


The backup was done a couple of days ago and in the meantime database A and database B have continued to be worked on. I dont think this has any effect on what I want to achieve but I'm just throwing it in.


System:
I have MS SQL Server Management Studio 10.5 (MS SQL Server 2008 R2) running on Windows Server 2008 Std SP2 (it's not R2).

 

[Deleted member 12106]

LOL so much of this thread reads like calls at work...

Try this: https://msdn.microsoft.com/en-us/library/ms190209.aspx

 

[bigdogchris]

You can backup into a backup device then import from that device into another database.

 

[bloodypulp]

if you have MDF/LDF files, you Attach the database(Not Restore).
Right-click on the Databases folder in the tree.
Left-click on Attach.
Add the MDF.