| |
Location: Blogs OpenDNN blogOpen-DocumentLibrary |
 |
| Posted by: Xepient Solutions |
7/26/2007 |
O-DL needs an extra step when you restore a DNN DB backup from one server to another. This article will show you how not to loose data.
- First modify the xsdl_RootFolderPath entry in the ModuleSettings table to your new Root Folder Path.
- Then execute this sql
---------------------------------------------------------------------------------
declare @OldRootFolderPath nvarchar(256)
declare @NewRootFolderPath nvarchar(256)
--example
set @OldRootFolderPath = 'c:\dotnetnuke\dotnetnuke4.5.3\portals\0\'
set @NewRootFolderPath = 'd:\dotnetnuke\dotnetnuke4.5.3\portals\0\'
update xsdl_Folder
set FolderPath = REPLACE(FolderPath, @OldRootFolderPath,@NewRootFolderPath)
from xsdl_Folder
GO
---------------------------------------------------------------------------------
AS IS. please check this code for correctnes.
|
|
| Permalink |
Trackback |
Comments (1)
Add Comment
|
Re: How do I maintain a dev server for testing and not lose information? |
By host on
9/25/2007 |
| Hi, yes, it was tested in a webfarm environment and it was reported working.<br><br>Make sure you change the values in the @OldRootFolderPath and @NewRootFolderPath parameters before executing the SQL statement.<br><br>Regards,<br>Xepient Solutions <br> |
|
|
|
|
|
|
|
|