Problem with restoring Sharepoint 2007 from backup
Hi,
I am trying to restore our production Sharepoint 2007 server into a virtual environment.
I made sure to install Service Pack 1 (v 12.0.0.6219) of Sharepoint, as that's what's running in the production environment.
From our production server, in Central Administration, I performed a full farm backup. Checking the log there were 0 errors:
[8/18/2010 3:57:04 PM]: Completed with 0 warnings.
[8/18/2010 3:57:04 PM]: Completed with 0 errors.
[8/18/2010 3:57:04 PM]: Backup completed successfully.
[8/18/2010 3:57:04 PM]: ---
Then I copy the backup directory to the virtual server and from Central Administration choose:
Restore From Backup. I point to the backup directory that I copied, choose the full farm, and choose New Configuration. I update everything accordingly and then click OK, and the restore fails miserably.
I won't paste the whole log, but here is what I get throughout, in regards to each database:
[8/19/2010 10:04:12 AM]: Error: Object WSS_Content_Restore (previous name: WSS_Content) failed in event OnRestore. For more information, see the error log located in the backup directory.
SqlException: The media family on device 'C:\SharepointBackup\spbr0
RESTORE DATABASE is terminating abnormally.
When I go into SQL Server Management Studio (I installed 2008 on the virtual server, because that's what's currently installed on our sharepoint server), and I try to manually restore the .bak file 0000001D.bak, I get the error:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
ADDITIONAL INFORMATION:
The media family on device 'C:\SharepointBackup\spbr0
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476
Why aren't the MS SQL Server databases restoring properly?
Thanks,
Jamie
I am trying to restore our production Sharepoint 2007 server into a virtual environment.
I made sure to install Service Pack 1 (v 12.0.0.6219) of Sharepoint, as that's what's running in the production environment.
From our production server, in Central Administration, I performed a full farm backup. Checking the log there were 0 errors:
[8/18/2010 3:57:04 PM]: Completed with 0 warnings.
[8/18/2010 3:57:04 PM]: Completed with 0 errors.
[8/18/2010 3:57:04 PM]: Backup completed successfully.
[8/18/2010 3:57:04 PM]: ---
Then I copy the backup directory to the virtual server and from Central Administration choose:
Restore From Backup. I point to the backup directory that I copied, choose the full farm, and choose New Configuration. I update everything accordingly and then click OK, and the restore fails miserably.
I won't paste the whole log, but here is what I get throughout, in regards to each database:
[8/19/2010 10:04:12 AM]: Error: Object WSS_Content_Restore (previous name: WSS_Content) failed in event OnRestore. For more information, see the error log located in the backup directory.
SqlException: The media family on device 'C:\SharepointBackup\spbr0
RESTORE DATABASE is terminating abnormally.
When I go into SQL Server Management Studio (I installed 2008 on the virtual server, because that's what's currently installed on our sharepoint server), and I try to manually restore the .bak file 0000001D.bak, I get the error:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
ADDITIONAL INFORMATION:
The media family on device 'C:\SharepointBackup\spbr0
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476
Why aren't the MS SQL Server databases restoring properly?
Thanks,
Jamie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can backup on the SQL Server 2008 instance using "files and filegroups" instead of a full backup. When you try to restore in SQL 2005, use
Tasks>Restore files and filegroups>Enter all the pertinent information as to what you want to call it, where to restore from>Click the restore box>Options (top left) and enter the location where you want it restored in the window to the right. After that, if you click OK, you will probably get an error. So instead, click on "Script" at the top of the screen and it will put the T-SQL commands in a query window right behind the window you are currently looking at. Copy and past that script to here, and I think I can change it to make it work for you.
I have never used Sharepoint, however I know that normally you can use SQL Server 2008 to upgrade a previous version.
Tasks>Restore files and filegroups>Enter all the pertinent information as to what you want to call it, where to restore from>Click the restore box>Options (top left) and enter the location where you want it restored in the window to the right. After that, if you click OK, you will probably get an error. So instead, click on "Script" at the top of the screen and it will put the T-SQL commands in a query window right behind the window you are currently looking at. Copy and past that script to here, and I think I can change it to make it work for you.
I have never used Sharepoint, however I know that normally you can use SQL Server 2008 to upgrade a previous version.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Zephyr,
Basically I just started at this company about 6 months ago and the Sharepoint server was already set up here. It has Sharepoint 2007 SP1 standalone, SQL Server 2008 Standard Edition and Project Server. SQL Server 2005 is NOT installed at all. When I ask them how they did this, nobody can remember.
I'll try to attach the MDF/LDF files and see if that works. It just shouldn't have to be that way. (Just the content database is 130GB between the MDF and LDF files so I'll be transferring for the rest of the day today)
I'd still really like to be able to either import .bak files or have the Central Administration site do it for me.
Is there a way to know which version of SQL Server a database was created in?
Basically I just started at this company about 6 months ago and the Sharepoint server was already set up here. It has Sharepoint 2007 SP1 standalone, SQL Server 2008 Standard Edition and Project Server. SQL Server 2005 is NOT installed at all. When I ask them how they did this, nobody can remember.
I'll try to attach the MDF/LDF files and see if that works. It just shouldn't have to be that way. (Just the content database is 130GB between the MDF and LDF files so I'll be transferring for the rest of the day today)
I'd still really like to be able to either import .bak files or have the Central Administration site do it for me.
Is there a way to know which version of SQL Server a database was created in?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's WSS.
The path is:
C:\Program Files\Microsoft SQL Server\MSSQL10.SHAREPOINT\
The path is:
C:\Program Files\Microsoft SQL Server\MSSQL10.SHAREPOINT\
then it's likely to be SSEE. unless someone was being less than brilliant and installed WSS with SQL Express (SQL Express has limitations, and so it's crazy to choose it rather than SSEE which does not have those limitations).
ASKER
Here's the steps I ended up taking to run my successful restore:
--Install SQL Server 2008 (when prompted, choose Sharepoint Integrated Mode Default Configuration)
--Install Sharepoint
--Choose New farm
--Use the database instance you created when setting up SQL Server 2008
--Run the wizard
--Copy STSADM backup files to server
--Assign FULL security to these files
--From central administration go to Operations->Restore From Backup
--Choose New configuration
--Triple check ALL fields to make sure they are pointing to the correct paths on the new server.
After I did this, I was able to open restored sites from the web browser.
There is some additional configuration to do from Central Admin: ie, starting services, configuring indexing...etc.... I'm not really too worried about that right now. Just joyed that I finally got this to work.
Thanks everyone for getting me on the right path.
--Install SQL Server 2008 (when prompted, choose Sharepoint Integrated Mode Default Configuration)
--Install Sharepoint
--Choose New farm
--Use the database instance you created when setting up SQL Server 2008
--Run the wizard
--Copy STSADM backup files to server
--Assign FULL security to these files
--From central administration go to Operations->Restore From Backup
--Choose New configuration
--Triple check ALL fields to make sure they are pointing to the correct paths on the new server.
After I did this, I was able to open restored sites from the web browser.
There is some additional configuration to do from Central Admin: ie, starting services, configuring indexing...etc.... I'm not really too worried about that right now. Just joyed that I finally got this to work.
Thanks everyone for getting me on the right path.
ASKER
Sorry, I'm not the best with SQL Server stuff.