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?
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
0
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/
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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
0
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
0
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
0
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

0
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
0
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
0
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
0
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?
0

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.