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 - 2003-04-11 : 07:16:12
|
| Manikandan writes "hi frnds I want to know that if we are having many database on same server. We are putting the .mdf,.ldf file on a folder with name backup. so can i take the back up of all the database with a single backup command with out stoping the server.is that possible , plzzz help me to know more details about this.thanx..." |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-11 : 09:29:24
|
| You cannot copy the files (.mdf, .ldf) without stoping the server or detaching the databases. Use Database Maintanence Wizard to schedule and backup the database.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey.Edited by - samsekar on 04/11/2003 09:30:35 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-11 : 13:50:41
|
| Instead of using the Database Maintenance Wizard, just create your own BACKUP DATABASE commands so that you have more flexibility. Then schedule these commands by creating a job.Tara |
|
|
|
|
|
|
Database Backup