• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 916
  • Last Modified:

Extracking SQL database out of a Stsadm backup

Is there a way to extract the SQL backup from a Stsadm Backup? I need the content database. Here is the command line being used.

Stsadm -o backup -url http://localhost -filename f:\sp_backup\sharepoint.bak -overwrite
0
RickEpnet
Asked:
RickEpnet
  • 6
  • 5
  • 3
1 Solution
 
Minesh ShahSharePoint & all about itCommented:
so you are asking .bak to conert into a sql db means .mdf & .ldf.
if it is the case, you can do it:
go to ssms,
right click on databases > restore > select the path of .bak & ok.

let us know if i have deviated.
0
 
RickEpnetAuthor Commented:
The .bak file was not created as a SQL backup.

It was give the file name with a .bak via the command line utility Stsadm. This is used to backup SharePoint. I know SQL backup by default have the .bak extension but this is not a SQL backup.  
0
 
Minesh ShahSharePoint & all about itCommented:
sorry i am still unable to read you.
please elaborate how & of what the bak up you have..
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RickEpnetAuthor Commented:
This was the command line that did the backup.

Stsadm -o backup -url http://localhost -filename f:\sp_backup\sharepoint.bak -overwrite

This backs up everything not just the databases. I want the databases out of it?

Does that explain it?
0
 
Minesh ShahSharePoint & all about itCommented:
well,
you can use this for taking back up of an individual content db:
stsadm –o backup –url <URL of the site collection> -filename <Name of the backup file>

may refer this:
http://technet.microsoft.com/en-us/library/cc288090(office.12).aspx
0
 
RickEpnetAuthor Commented:
I do not have access to the server I only have the file.
0
 
Minesh ShahSharePoint & all about itCommented:
just like you received this file you may ask for other as well!!!
0
 
Minesh ShahSharePoint & all about itCommented:
i have never tried extracting single content db from command you posted,
i always like to keep things pretty simple.
0
 
GeorgeGerguesCommented:
The bak / dat file is a cab file.

Rename the file to .CAB and decompress with any ZIP / Unzip tool like winrar.

you should see the SQL backup file inside (.DAT file I do not recall )

Best of luck
0
 
RickEpnetAuthor Commented:
That did not seem to work.
0
 
GeorgeGerguesCommented:
whcih version of SharePoint
0
 
GeorgeGerguesCommented:
I Do apologize that was a backup not an export.


Ok ,here is another trick
try restoring the backup    using the -newdatabaseserver and -new swtich  into another  farm or testbed .

this will create a  new content database for you to work on .

hope that helps.
0
 
RickEpnetAuthor Commented:
I was hoping it would not come to that but I might try it.
0
 
RickEpnetAuthor Commented:
I guess this is the only option.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 6
  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now