I have took a backup of our live content database using the following command:-
Backup-SPFarm -Directory \\servername\f -BackupMethod Full -Item WSS_Content_ea05******15e8 -Verbose
which generated these two compenents:-
- spbrtoc xml file
- spbr0000 folder which contain a list of .bak files.
now i want to restore this content database on our test server ? but not sure that i should specify inside these parameters for the Restore-SPFarm
command:-
-Directory. should it be referencing the folder or certain file inside the spbr0000 folder?
-BackupId. should this be a random number ?
EDIT now i try running this command on test machine:-
Restore-SPFarm -Directory T:\fileserver\farm -RestoreMethod new -Item WSS_Content_copyLive -Verbose
where the T:\fileserver\farm
is a folder which contain the backup folder spbr0000.. and i gave the content database a new name WSS_Content_copyLive
, but this script raised the following error:-
Verbose: Using directory: T:\fileserver\farm\spbr0000\.
Verbose: Initializing objects for restore.
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Adding WSS_Content_ea05119bb8a4408ab450dcd46d6015e8 to Restore list.
Verbose: Searching for item: Farm\Microsoft SharePoint Foundation Web Applicatio
n\SharePoint - 80\WSS_Content_ea05119bb8a4408ab450dcd46d6015e8.
Verbose: Found 1 item(s).
Verbose: Adding WSS_Content_ea05119bb8a4408ab450dcd46d6015e8 to Restore list.
Verbose: Searching for item: WSS_Content_copyLive.
Verbose: Found 0 item(s).
Restore-SPFarm : Item WSS_Content_copyLive not found.
At line:1 char:1
+ Restore-SPFarm -Directory T:\fileservert\farm -RestoreMethod new -item
WSS_ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
+ CategoryInfo : InvalidData: (Microsoft.Share...dletRestoreFarm:
SPCmdletRestoreFarm) [Restore-SPFarm], SPException
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRestoreF
arm
VERBOSE: Leaving ProcessRecord Method of Restore-SPFarm.
VERBOSE: Leaving EndProcessing Method of Restore-SPFarm.
EDIT-2 now i tried defining the same content database name as on the live server:-
Restore-SPFarm -Directory T:\fileserver\farm -RestoreMethod new -Item WSS_Content_ea05119bb8a4408ab450dcd46d6015e8 -Verbose
i got these on the cmd window:-
verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Initializing SPPersistedObject State
Verbose: Adding WSS_Content_ea05119bb8a4408ab450dcd46d6015e8 to Restore list.
Verbose: Searching for item: Farm\Microsoft SharePoint Foundation Web Applicatio
n\SharePoint - 80\WSS_Content_ea05119bb8a4408ab450dcd46d6015e8.
Verbose: Found 1 item(s).
Verbose: Adding WSS_Content_ea05119bb8a4408ab450dcd46d6015e8 to Restore list.
Verbose: Searching for item: WSS_Content_ea05119bb8a4408ab450dcd46d6015e8.
Verbose: Found 1 item(s).
Change location/name for: Farm\Microsoft SharePoint Foundation Web Application\
SharePoint - 80\WSS_Content_ea05119bb8a4408ab450dcd46d6015e8
Log file location: (default: L:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\Data
):
now i went to my dev machine database,, but i can not find the database insdie the sql server? also from the output i find this
L:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\Data
but on my dev this folder does not exists, it is the folder inside the live .. can anyone advice on this please ?