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).
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).
Last edited: