SQL Server - Web tool to backup/restore

Hi,

Does anyone know any web tool (free or not) to backup/restore SQL Server database, logically using a user with administrator privileges?

Thanks in advance,

Marcelo Camarate
Marcelo CamarateAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Marcelo CamarateAuthor Commented:
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
Kanti PrasadCommented:
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/
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Marcelo CamarateAuthor Commented:
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
Kanti PrasadCommented:
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
Marcelo CamarateAuthor Commented:
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
TemodyPickalbatros, IT ManagerCommented:
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

Open in new window

Marcelo CamarateAuthor Commented:
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
TemodyPickalbatros, IT ManagerCommented:
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
Marcelo CamarateAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
don't have the sa password. I can only access the database using its owner user.
As per your comment in another question thread, the dbowner is a SQL login so with no access to system folders and files and without that isn't able to perform the backup.


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".
How do you want to perform a backup without running a backup command?

By the way, how are the regular backups being performed on that database?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.