Monday, February 20, 2012

Online Backup

Hello There Does anyone know how can i make an online backup with taking the
database offline
thank yousorry i mean without taking the database in offline mode
"Amir Fahmy" wrote:
> Hello There Does anyone know how can i make an online backup with taking the
> database offline
> thank you
>|||Hello,
You could always perform the database backup online. All the below backups
types in SQL Server are online.
1. FULL DATABASE Backup
2. Transaction Log Backup
3. Differential Backup
Take a look into BACKUP DATABASE, BACKUP LOG and Recovery Models topic in
SQL Server books online.
Thanks
Hari
"Amir Fahmy" <AmirFahmy@.discussions.microsoft.com> wrote in message
news:55EB6BB3-ACA4-4CDC-8E1F-09D1DD3CD122@.microsoft.com...
> Hello There Does anyone know how can i make an online backup with taking
> the
> database offline
> thank you
>

No comments:

Post a Comment