This can be downloaded here http://www.gruposur.com.uy/Descargas/tabid/96/Default.aspx

It's a simple module that allows you to perform a database backup, compress it and download it.
IMPORTANT NOTE: this module works when the database and the web server hosting the portal is the same.

English and Spanish resource files are included.
The module is automatically added to the Host menu ("DNN Backup" option).

Regards,
Horacio.-

Horacio - I just tried out your module - thanks for that - this is really handy!

Thank you for doing this..
You need a little icons for the host menu setting - do you want me to send you one..

I am really impressed by the cool ideas you guys come up with.

Nina Meiers

---

Nina Meiers

This is a very handy module indeed.

At the risk of sounding like a complete idiot ( no laughing please), how do I restore the bkp file?

---

Icthus Technologies

Building Faith on the Internet

Hello Horacio,

This is a nice module indeed!

Just two questions:

1st: can this module be scheduled? In that case I could run a backup every night automatically.

2nd: When will it be possible to backup a database that is located on an other server? This because I run a portal on Webhost4Life, and they use sepatate database servers.

Thanks alot for your work so far!

Jos Richters

 

---

www.visualdata.nl
"He who pretends to know everything does't know much!" Keep on asking!

Horacio,

As you may already be aware, the install fails in 3.1. If it was installed in 3.0.13 the upgrade works fine.

StartJob

Start Sql execution: 01.00.00.SqlDataProvider file

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure 'AddDesktopModule' expects parameter '@IsAdmin', which was not supplied. Procedure 'AddModuleDefinition' expects parameter '@DefaultCacheTime', which was not supplied. INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Modules_ModuleDefinitions'. The conflict occurred in database 'lcmstexas-31', table 'ModuleDefinitions', column 'ModuleDefID'. INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_TabModules_Modules'. The conflict occurred in database 'lcmstexas-31', table 'Modules', column 'ModuleID'. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SQLDataProvider *****/ /***** BackupLite *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ DECLARE @PageIndex int DECLARE @ModuleDefID int DECLARE @DesktopModuleID int DECLARE @ModuleIcon nvarchar(100) DECLARE @ModulePageName nvarchar(128) DECLARE @ModuleFriendlyName nvarchar(128) SET @ModuleIcon = 'icon_BackupLite_32px.gif' SET @ModulePageName = 'DNN Backup' SET @ModuleFriendlyName = 'GrupoSur.BackupLite' IF (SELECT COUNT (*) FROM dbo.Tabs WHERE TabName = @ModulePageName) = 0 BEGIN EXEC AddTab NULL, @ModulePageName, 1, 0, 7, NULL, @ModulePageName, '', '', '', NULL, NULL, '//Host//DNN Backup', NULL, NULL SELECT @PageIndex = TabID FROM dbo.Tabs WHERE TabName = @ModulePageName IF (SELECT COUNT(*) FROM dbo.ModuleDefinitions WHERE FriendlyName = @ModuleFriendlyName)=0 BEGIN -- Thanks to DNNUpdate: -- Module not installed. DNN executes SQL before the DesktopModule is -- registered. We must allocate the module a ModuleDefID and -- DesktopModuleID so we can create an admin page. Because the -- FriendlyName will match when the 'real' registration happen, the -- ID numbers will stay the same. See PAInstallerBase.RegisterModules -- for code execution flow. EXEC AddDesktopModule @ModuleFriendlyName, '', '0', 0, 1, '' SET @DesktopModuleID = @@IDENTITY EXEC AddModuleDefinition @DesktopModuleID, @ModuleFriendlyName SET @ModuleDefID = @@IDENTITY END ELSE BEGIN -- Thanks to DNNUpdate: -- This bit should not ever get executed, since the SQL will only -- ever get run the first time the module is installed (so it won't be -- registered in the datbase yet) SELECT @ModuleDefID = ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = @ModuleFriendlyName SELECT @PageIndex = TabID FROM dbo.Tabs WHERE TabName = @ModulePageName END --END IF EXEC AddModule NULL, @ModuleDefID, @ModuleFriendlyName, 0, NULL, NULL, NULL, NULL, 1, 0 EXEC AddTabModule @PageIndex, @@IDENTITY, 1, 'ContentPane', 0, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 0 END

---

Icthus Technologies

Building Faith on the Internet

Thanks Nina!

I really appreciate your comments and an icon will be welcome.

Regarding to the icon, in fact I tried do add one but it seems like it needs to be at the root  "/images" folder. I didn't find a way to reference one in the "/desktopmodules/GrupoSur.BackupLite" folder.
If you (or someone) knows how to work around this...

IcthusTech wrote:

This is a very handy module indeed. At the risk of sounding like a complete idiot ( no laughing please), how do I restore the bkp file?

Hi,

You mean local restore (your dev/test box) or restore it a the real remote (ISP) site?

The problem is that a database cannot be in use to be restored.
Also you have to deal with the restrictions that your ISP imposed to your SQL account.
With the necessary permissions you could kill all current connections (asp.net may keep some opened although nobody seems to be accessing your site) and then perform a restore but unless you are your own ISP, chances that you can perform this type of operations are very low.

I've been playing trying to work around this, but without the rights permissions it couldn't be done.
If someone knows a way, I'll add the "restore" functionality to the module in a rush.

To perform a local restore, you can use the Enterprise Manager (the graphical way), Query Analyzer if you have SQL Sever or something like Toad for SQL Server (free great tool form Quest Software http://www.quest.com/) if not, to perform this operations:

-- First you should find the LogicalName and PhysicalName of the original database
RESTORE FILELISTONLY
FROM DISK = 'c:\mysite.bkp'
GO

-- Then you can perform the restore operation (if nobody is using it)
-- You should replace 'c:\mysite.bkp', 'logical_data',
-- 'C:\myfolder\mysubfolder\mydatabase_Data.MDF', etc. with the real ones
restore database mydatabase
FROM DISK = 'c:\mysite.bkp'
WITH
   MOVE 'logical_data' 
     TO 'C:\myfolder\mysubfolder\mydatabase_Data.MDF',
   MOVE 'logical_log' 
     TO 'C:\myfolder\mysubfolder\mydatabase_Data.LDF'
GO

Note: to know who is locking a database you can use "sp_who" and to kill the desired processes you can issue "kill" commands.

Regards,
Horacio.-

JosRichters wrote:

Hello Horacio, This is a nice module indeed! Just two questions: 1st: can this module be scheduled? In that case I could run a backup every night automatically. 2nd: When will it be possible to backup a database that is located on an other server? This because I run a portal on Webhost4Life, and they use sepatate database servers. Thanks alot for your work so far! Jos Richters

Hi Jos,
Thanks for your feedback.
Regarding to your questions:
1) This is a feature planned for a future release.

2) Short answer:Yes
But:
a) The module would be configured with a well known full path/folder of the database box where the backup file well be placed. Currently the backup folder can only be configured (Module Setting section) to point to a folder under the root web site (web server box).
b) To be useful, you should have a way to access the resulting backup file from outside. Note that normally you are not able to see a file that is not somewhere in your web site path.

Change the module to resolve (a) it's easy but you should ask Webhost4Life for that full folder path at the database server box. ?Is this possible?
Then to resolve (b) you shoud ask your ISP for a way to access that file from outside.

I see a red blinking alarm (security stuff) that makes (a) and (b) not friendly to your ISP, but if not, make me know it and I'll be pleased to make this little changes to the module.

Thanks,
Horacio.-

Horacio,

Thanks very much for your help. Here is how I plan on using your module.

I have several installations that I back up every day using Enterprise Manger. I like to do a weekly offsite backup that I use for emergency recovery if something should happen to one of the hosting boxes. What I would like to be able to do is take the downloaded bkp file, upload it to a new server and restore it to a new db using EM.

What I really like about your module is that it allows me to have different people in my company be responsible for offsite backup so I can be sure it gets offsite relaibly.

Can I do what I think I can?

---

Icthus Technologies

Building Faith on the Internet

IcthusTech wrote:

Horacio, As you may already be aware, the install fails in 3.1. If it was installed in 3.0.13 the upgrade works fine.

Hi,

I've uploaded a new version, compatible with DNN 3.1. 
The old one is still there for all the 3.0.X users.

Regards,
Horacio Judeikin
www.gruposur.com.uy

PS: Today I became aware that this thread was active (thanks Jack Hoelz for your post at GrupoSur) .

IcthusTech wrote:

I have several installations that I back up every day using Enterprise Manger. I like to do a weekly offsite backup that I use for emergency recovery if something should happen to one of the hosting boxes. What I would like to be able to do is take the downloaded bkp file, upload it to a new server and restore it to a new db using EM. What I really like about your module is that it allows me to have different people in my company be responsible for offsite backup so I can be sure it gets offsite relaibly. Can I do what I think I can?

I'm not sure to understand what you would like to do, but note that:
- if you have access to the server (you can use EM) so it looks like you don't need this module. In fact, you can schedule SQLServer to make the backups for you. To transfer them offsite, you can use any ftp automation utility to send the backup files to anywhere you want or you can backup to tape, USB storage or whatever.
- multiple portals at the same DNN host shares their database, so are backed up together. You can set up multiple instances of the backup module, with different settings, but all ends up storing the same database.

What I would like to be able to do is take the downloaded bkp file, upload it to a new server and restore it to a new db using EM

No matter the tool, script or module that performed the backup, you can do that. But (always a "but") to replicate your actual site you probably will need at least a compatible web.config file (MachineValidationKey, MachineDecryptionKey and all that stuff)

Thanks for the info and thanks for the update!

Yes, I already have EM doing a Backup daily at 2:00 am, does all the db's, then I use an automated ftp manager to grab a backup and download it once a week. Whats so handy about your module is the fact I don't need to FTP in, which means I don't need to give others that backup for me any FTP accounts. And this allows the backups to be at multiple locations providing even another level of reliability.

Thanks for the reminder about the webconfigs, didnt think about the keys, should have been reminded when I upgraded.

Great module, thanks again.

---

Icthus Technologies

Building Faith on the Internet

Hello Horacio,
I know the path on the WH4L server. Its the standard path under witch MSSQL is installed.
Furthermore, I can access my other directory (with the DNN on it) on WH4L, both thru FTP and via a webbrowser.

Normally, when I make a backup on WH4L, I get the IP adress from witch I can download the bakupfile through FTP.
Is this the way I can retreive the backupfile as it is created by your module?

Thanks,
Jos

---

www.visualdata.nl
"He who pretends to know everything does't know much!" Keep on asking!

New BackupLite 1.0.2 version (for DNN 3.0 and DNN 3.1) available for download at http://www.gruposur.com.uy/Descargas/tabid/96/Default.aspx

History

01.00.00
- initial release for DNN 3.0
01.00.01
- setup script updated for DNN 3.1
01.00.02
- supports database and web servers in different boxes
- always provides a downolad link to the last compressed backup (showing it's date/time)

Regards,
Horacio.-

Hi,

A new version of the BackupLite module was released.
Compatible with DNN 3.0.12, 3.0.13, 3.1.0 & 3.1.1

v 2.0.0

September 29, 2005 - maximized request timeout protection - visual enhancements - automatic detection of remote databases - always provides a download link to the last backup (compressed or not) - new method to activate the downloads (more "download managers friendly") - PRO edition released (see features below). Available at Snowcovered, w/source code.

Free edition - Functionality

• No ftp access required for your backup needs.
• No administrative rights required.
• Optional zip database backup file generation.
• Enabled direct download of the last generated (compressed or not) backup files.

http://www.gruposur.com.uy/Default.aspx?tabid=96

Pro edition - Additional functionality

• Optionally backups all the portals content (files and folders under the web site /Portals folder), plus the web.config file
• Scheduled backups are enabled: Every time you configure the module settings, a scheduled task is automatically configured (with optional email notifications of successful or failed backups).
  You DON'T need any administrative right to configure your scheduled task options. You can configure it directly from the module settings.
• Optionally, date & time appended to each backup. Each backup operation will produce a different backup file.
• Configurable compression level for the compressed ZIP file creation.
• Automated configurable deletion of older backup files .
• Instead of produce many backup files you can have one with many backups turning off the "Initialize Store" setting (allows you to choose between "WITH INIT" and "WITH NOINIT" backups).
• Backup History Manager: DNN File Manager like dialog, where you can download, compress or delete any file found on the configured backup folder.

http://www.snowcovered.com/snowcovered2/Default.aspx?tabid=166&CatalogItemID=2236

 

Thanks,
Horacio.-

how do you set it up to connect to a remote database server? can it use the connection from the web.config?

---

Have a Go Daddy / WWD question? PM Me!
Domains and Hosting at Airdepth.net - Free Web Software Install
Go Daddy / WWD Reseller Stores for less at Metrodatacenter.net with Personal Support

mannyd wrote:

how do you set it up to connect to a remote database server? can it use the connection from the web.config?

That's true. It uses de DNN configuration. The SQL Server database backup command is always issued at the database server, not the web server.

HTH,
Horacio.-

vers. 2.0.2

rewritten database backup functionallity. Now not using Microsoft.ApplicationBlocks.Data.dll  (Working with the Data Access Application Block, you cannot specify an sql command timeout) added backup options for \bin, \desktopmodules and all the others folders on the site if a scheduled backup fails, now the detailed error is directly included on the notification email now all tasks (database backup, files & folders backup, purge old backups, compressing, etc.) occurs on a new independent thread of execution. Every 2 seconds the page is automatically refreshed until the whole process is completed. The current status percentage of completion is shown at real time.

Hi,

On GrupoSur, we are moving DNN specific stuff to http://www.evotiva.com

Version 2.1 of the BackupNative module has been released (due to it's confusing name, BackupLite module was renamed to BackupNative)
http://www.evotiva.com/Modules/BackupNative/tabid/56/Default.aspx
- DNN 4 build
- database restore support
- more


You may be also interested on the new BackupScript (FREE/DEMO and Registreded version) module: http://www.evotiva.com/Modules/BackupScript/tabid/57/Default.aspx
- local/remote database (any size) backup & restore (as standard .SQL files)
- full site files backup
- portal files restore
- database structure scripting (as standard .SQL files)
- more

Thanks!
Horacio.-