backup sql server online

Hi,
I new to sql database server administration. Currently I had a sql server
running on an win2000 server. Every night there is a full system backup, it
will backup all the hardisk partitions contents to tape. The sql server
services are not stop.
1.) By backuping up the sql server database online, will it cause any
corruption to the database?
2.) Is the database backup valid? If there is a media failure, can we used
the backup for recovery?
3.) How to apply the latest changes to the database if some changes was not
been backup?
4.) Any link/documents that I can refer to for the sql database server backup?
Thank You.This is not the recommended method of backing up SQL Server databases.
Because SQL Server is running during the backup the files will either
be 'open' and therefore not backed up properly or, if the backup
software is intelligent enough to be able to back these up, it still
doesn't give you recovery to a given point.
If you look at SQL Bokks Online you will find reference to Backups.
There are wizards that let you set up SQL Maintenance Plans. You may
need to also do regular Transaction Log Backups, dependent upon the the
Database Mode and what your recovery requirements are.
Regards
ALI
bin wrote:
> Hi,
> I new to sql database server administration. Currently I had a sql server
> running on an win2000 server. Every night there is a full system backup, it
> will backup all the hardisk partitions contents to tape. The sql server
> services are not stop.
> 1.) By backuping up the sql server database online, will it cause any
> corruption to the database?
> 2.) Is the database backup valid? If there is a media failure, can we used
> the backup for recovery?
> 3.) How to apply the latest changes to the database if some changes was not
> been backup?
> 4.) Any link/documents that I can refer to for the sql database server backup?
> Thank You.|||No. File system backups aren't really good for SQL Server databases. SQL
Server provides a native and online way to backup the databases, using the
BACKUP command. Databases can be restored from these backup files (created
by BACKUP command), using the RESTORE command.
See SQL Server 2000 Books Online for more information on how Backup and
Restore work. Also check out the database manintenance wizard in SQL Server
Enterprise Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"bin" <bin@.discussions.microsoft.com> wrote in message
news:572878EE-7CF2-487F-B720-AB9F54635B9F@.microsoft.com...
Hi,
I new to sql database server administration. Currently I had a sql server
running on an win2000 server. Every night there is a full system backup, it
will backup all the hardisk partitions contents to tape. The sql server
services are not stop.
1.) By backuping up the sql server database online, will it cause any
corruption to the database?
2.) Is the database backup valid? If there is a media failure, can we used
the backup for recovery?
3.) How to apply the latest changes to the database if some changes was not
been backup?
4.) Any link/documents that I can refer to for the sql database server
backup?
Thank You.|||Hi,
So if the sql server services are shutdown before the backup. It should
be ok right?
"Narayana Vyas Kondreddi" wrote:
> No. File system backups aren't really good for SQL Server databases. SQL
> Server provides a native and online way to backup the databases, using the
> BACKUP command. Databases can be restored from these backup files (created
> by BACKUP command), using the RESTORE command.
> See SQL Server 2000 Books Online for more information on how Backup and
> Restore work. Also check out the database manintenance wizard in SQL Server
> Enterprise Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "bin" <bin@.discussions.microsoft.com> wrote in message
> news:572878EE-7CF2-487F-B720-AB9F54635B9F@.microsoft.com...
> Hi,
> I new to sql database server administration. Currently I had a sql server
> running on an win2000 server. Every night there is a full system backup, it
> will backup all the hardisk partitions contents to tape. The sql server
> services are not stop.
> 1.) By backuping up the sql server database online, will it cause any
> corruption to the database?
> 2.) Is the database backup valid? If there is a media failure, can we used
> the backup for recovery?
> 3.) How to apply the latest changes to the database if some changes was not
> been backup?
> 4.) Any link/documents that I can refer to for the sql database server
> backup?
> Thank You.
>
>|||Well, if the SQL Server Services are stopped and then the O/S level
backup is carried out then this wil give you usable SQL database files
for potential recovery but this is still not the 'correct' way of going
about this!
Use SQL's native BACKUP to backup the database(s) then run the O/S
level backups against the files created by the BACKUP.|||Probably, if you are willing to shutdown the SQL Server while the files are
backed up. But there's no guarantee that a file that wasn't properly
detached using sp_detach_db, can be attached to SQL Server using
sp_attach_db. As someone else also said, it is not a recommended practice.
Use Backup Restore instead.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"bin" <bin@.discussions.microsoft.com> wrote in message
news:E4D44FD0-96E2-4296-B628-88F9C26A5634@.microsoft.com...
Hi,
So if the sql server services are shutdown before the backup. It should
be ok right?
"Narayana Vyas Kondreddi" wrote:
> No. File system backups aren't really good for SQL Server databases. SQL
> Server provides a native and online way to backup the databases, using the
> BACKUP command. Databases can be restored from these backup files (created
> by BACKUP command), using the RESTORE command.
> See SQL Server 2000 Books Online for more information on how Backup and
> Restore work. Also check out the database manintenance wizard in SQL
Server
> Enterprise Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "bin" <bin@.discussions.microsoft.com> wrote in message
> news:572878EE-7CF2-487F-B720-AB9F54635B9F@.microsoft.com...
> Hi,
> I new to sql database server administration. Currently I had a sql
server
> running on an win2000 server. Every night there is a full system backup,
it
> will backup all the hardisk partitions contents to tape. The sql server
> services are not stop.
> 1.) By backuping up the sql server database online, will it cause any
> corruption to the database?
> 2.) Is the database backup valid? If there is a media failure, can we used
> the backup for recovery?
> 3.) How to apply the latest changes to the database if some changes was
not
> been backup?
> 4.) Any link/documents that I can refer to for the sql database server
> backup?
> Thank You.
>
>sql