is SQL WEB ADMIN safe to using as backup and restore database

Question

is SQL WEB ADMIN safe to using import and export as  backup and restore database? and how to make SQL WEB ADMIN attach only to selected database?thanks.

Answer 1

is SQL WEB ADMIN safe to using import and export as  backup and restore database?

Since it works as typical website, It depends on how you secured your ISS over the network, If you have firewall on your organization and your secured your network, Yes it is secure.

How to make SQL WEB ADMIN attach only to selected database?
I do not think we can do attach and dittach the databases using SQL WEB ADMIN.

---

Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.

Answer 2

thank for your reply rajesh.
sorry about the secure thing,i don`t explain it, i mean secure is backup and restore database same like original database (store procedure, trigger, table,views,security and data it self) is 100 % same like backup and restore using sql server manually, because in sql web admin the database generate to sql query (.sql).
thanks.

Answer 3

In that way, I believe there is no diffeence in security wise restoring the database through SQL query or through EM or SSMS

---

Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.

Answer 4

ok, it mean that backup using sql web admin the ''database contain '' (store procedure, trigger, table,views and data it self), is 100% same like backup using ssms?
thanks.

Answer 5

Yes that is right

---

Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.

Answer 6

ok, thanks a lot.