Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-15 : 23:38:04
|
| Tracy writes "I would like to backup the database in a application instead of going to SQL server enterprise Manager to do the administration work.Is it recommended if we backup a database by executing a stored procedure?" |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-16 : 02:27:39
|
| If you really want to do the back up through application, then you can use the system stored procedures.It is safe if you set all parameters carefully.---------------------------Sandesh - The Messanger |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-16 : 09:46:05
|
| It is plenty safe running backups from stored procedures. It's the only way to fly. The problem with your requirement is that you want to run the stored procedures from a remote connection. You'll need to make sure the user you are connecting as has the proper permissions, and that nothing is going to break that remote connection while the procedures are running.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Backup database