|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
A high performance database engine using optimized data access for all development environments including Delphi, Visual Studio .NET, Visual Basic, Visual FoxPro. and more. Learn More |
|
#1
|
||||
|
||||
|
How to backup of all databases
in mssql ? I want to put them on a folder . Any ideea or script ? |
|
#2
|
|||
|
|||
|
You can use Enterprise Manager to set up scheduled backups for each database, I don't know if there is a way to do all databases at once. The defaults will put the backups in a backup folder, you can choose to have all db backups end up in one folder, or have the backups go to separate subfolders by database.
You can set the backups to automatically clean out old copies, and backup the transaction log on a different schedule if you want. You can also use a scheduled DTS job to copy database data to another server. You can also set up replication of databases to another server. |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > automatic backing up mssql |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|