SQL Server - Web tool to backup/restore

Hi

Here are some free tools.

http://go.veeam.com/microsoft-sql-server-explorer.html
http://sqlbackupandftp.com/restore/
https://sqlbackupandftp.com/

Hi Kanti,

Thanks for your reply.

But, I looked your suggestions and, it seems, all need to be installed on a client machine, and this I can not do.

The reason is that I need to use it in my customer's environment, and is not allowed to install any client tool. The only option that I have is install a Web tool that  run under IIS.

Do you know a tool with these characteristics?

Regards,

Marcelo Camarate

Hi

Create a .bak file in your App_data directory on your site account using the SQL backup tool in our control panel and follow the below instruction on how to back up/restore your site and SQL databases with the help of IIS Manager

http://blog.winhost.com/how-to-back-uprestore-your-site-and-sql-databases-with-the-help-of-iis-manager/

Hi Kanti,

Thanks for you reply.

As I understand, to make just a database backup/restore, I need to using the WinHost site, right? But I need login an user in it, and its use is not free.

I can not purchase any product/service in my company that is not evaluated before,  and I not found any way to use it in trial mode. How do I use the WinHost for evaluation?

Regards,

Marcelo Camarate

Hi

Try the database manager module as you can backup and restore using it

http://www.iis.net/learn/extensions/database-manager/use-the-database-manager

Hi Kanti,

Thanks for your reply, but I can not install any module or extension in my customer IIS or Windows. The only thing I have permission to install is an IIS application developed in ASP.NET, and preferably in VB.NET.

Regards,

Marcelo Camarate

Please try this code as backup iob on SQL management

Declare @Sql nVarchar(500),
		@Name varchar(50),
		@Btype varchar(20)
	Set @Btype='Full' -- (Change the variable value according to backup type 1. 'Full' for full backup, 2. 'Differential' for differential backup, 3. 'Log' for transaction log backup
	Set @Sql=''
	Set @Name='your data name'
if @Btype='Full'
begin
Set @Sql='BACKUP DATABASE [' + @name + '] TO  DISK = N''your backup location'+@Name+'_'+@Btype+CONVERT(varchar, getdate(), 112)+'.bak'+''''+' WITH  INIT ,  NOUNLOAD,  NOSKIP , COMPRESSION, STATS = 10,  NOFORMAT '
Exec(@Sql)
--print @sql
Set @Sql = 'Restore VerifyOnly from Disk= N''your backup location'+@Name+'_'+@Btype+CONVERT(varchar, getdate(), 112)+'.bak'''
Exec(@Sql)
--PRINT(@Sql)
End
else if @Btype='Differential'
begin
Set @Sql='BACKUP DATABASE [' + @name + '] TO  DISK = N''your backup location'+@Name+'_'+@Btype+CONVERT(varchar, getdate(), 112)+'.bak'+''''+' WITH  INIT ,  NOUNLOAD,  NOSKIP , COMPRESSION,  STATS = 10,  NOFORMAT '+@Btype
Exec(@Sql)
--print (@Sql)
Set @Sql = 'Restore VerifyOnly from Disk= N''your backup location'+@Name+'_'+@Btype+CONVERT(varchar, getdate(), 112)+'.bak'''
Exec(@Sql)
--PRINT(@Sql)
end
else if @Btype='Log'
begin
Set @Sql='BACKUP Log [' + @name + '] TO  DISK = N''your backup location'+@Name+'_'+@Btype+CONVERT(varchar, getdate(), 112)+'.Trn'+''''+' WITH  INIT ,  NOUNLOAD,  NOSKIP , COMPRESSION, STATS = 10,  NOFORMAT '
Exec(@Sql)
--print (@Sql)
Set @Sql = 'Restore VerifyOnly from Disk= N''your backup location'+@Name+'_'+@Btype+CONVERT(varchar, getdate(), 112)+'.Trn'''
Exec(@Sql)
--PRINT(@Sql)
end

Select allOpen in new window

HI Temody,

Thanks for your reply, but I can not use the SQL commands "BACKUP" or "RESTORE", because the Database is on a different server of the IIS application server.

According security policies of  my customer, the database server does not maps any IIS server disk. Would that be an ASP.NET application that not use these commands.

Remembering, I can access the database using an owner user.

Regards,

Marcelo Camarate

Ok
If you have authorization SQL sa
You can linked the remote SQL Server to any local SQL Server you have via Remote SQL IP address
So you can apply any backup jobs as I mentioned above

Hi Temody,

Thanks for your reply.

I don't have the sa password. I can only access the database using its owner user.

And the SQL Management Studio is not installed on the IIS Server (remember that I only have access to this server), or any other SQL tools, and I don't have permission to install nothing different of an ASP.NET application.

For the above reasons, I think that my only option is an ASP.NET application that does not use the SQL commands "BACKUP" and "RESTORE".

Regards,

Marcelo Camarate