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.
>
>
Showing posts with label win2000. Show all posts
Showing posts with label win2000. Show all posts
Tuesday, March 27, 2012
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
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
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 backu
p?
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 serv
er
> running on an win2000 server. Every night there is a full system backup, i
t
> 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 no
t
> been backup?
> 4.) Any link/documents that I can refer to for the sql database server bac
kup?
> 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 Serve
r
> 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 serv
er
> running on an win2000 server. Every night there is a full system backup, i
t
> 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 no
t
> 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.
>
>
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 backu
p?
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 serv
er
> running on an win2000 server. Every night there is a full system backup, i
t
> 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 no
t
> been backup?
> 4.) Any link/documents that I can refer to for the sql database server bac
kup?
> 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 Serve
r
> 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 serv
er
> running on an win2000 server. Every night there is a full system backup, i
t
> 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 no
t
> 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.
>
>
Monday, March 19, 2012
Backup process hanging?
Hi everybody
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/Risun
Hi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun
|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun
>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
>news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
>
>.
>
|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun
|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/default...microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx.gbl...[vbcol=seagreen]
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
> execute the below
> with init , stats=10
> and stats=10 , will
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/Risun
Hi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun
|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun
>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
>news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
>
>.
>
|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun
|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/default...microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx.gbl...[vbcol=seagreen]
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
> execute the below
> with init , stats=10
> and stats=10 , will
Backup process hanging?
Hi everybody
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/RisunHi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx
.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun
>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
> news:1f69101c45781$a986adb0$a001280a@.phx
.gbl...
>
>.
>|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx
.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/defaul...microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx
.gbl...[vbcol=seagreen]
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
>
> execute the below
> with init , stats=10
> and stats=10 , will
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/RisunHi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx
.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun
>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
> news:1f69101c45781$a986adb0$a001280a@.phx
.gbl...
>
>.
>|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx
.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/defaul...microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx
.gbl...[vbcol=seagreen]
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
>
> execute the below
> with init , stats=10
> and stats=10 , will
Backup process hanging?
Hi everybody
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/RisunHi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
--
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun
>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
>news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
>> Hi everybody
>> OS is Win2000 with latest SP.
>> Microsoft SQL Server 7.00 - 7.00.842.
>> The problem is that there is a backup-process that is
>> runnable but wont finish or timeout. When i am trying to
>> kill the process nothing happens. It is still there!?!
>> Can someone maybe give some pointers to what i should do
>> to get ride of this process.
>> As it is now i cannot take a backup of the database the
>> backup process is hanged on.
>> /Risun
>
>.
>|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx.gbl...
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
> >--Original Message--
> >Hi,
> >
> >From the SQL Server machine, Open Query Analyzer and
> execute the below
> >comamnd and see whether it suceeds.
> >Ensure that an existing Backup process is not going on.
> >
> >BACKUP database <dbname> to disk='d:\backup\dbname.bak'
> with init , stats=10
> >
> >Init parameter will overwrite the backup filr every time
> and stats=10 , will
> >show the percentage completed.
> >
> >Note:
> >
> >See the CPU and Memory usage of server.
> >
> >--
> >Thanks
> >Hari
> >MCDBA
> >"Risun" <risun@.wmdata.com> wrote in message
> >news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> >> Hi everybody
> >>
> >> OS is Win2000 with latest SP.
> >> Microsoft SQL Server 7.00 - 7.00.842.
> >>
> >> The problem is that there is a backup-process that is
> >> runnable but wont finish or timeout. When i am trying to
> >> kill the process nothing happens. It is still there!?!
> >>
> >> Can someone maybe give some pointers to what i should do
> >> to get ride of this process.
> >> As it is now i cannot take a backup of the database the
> >> backup process is hanged on.
> >>
> >> /Risun
> >
> >
> >.
> >
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/RisunHi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
--
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun
>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
>news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
>> Hi everybody
>> OS is Win2000 with latest SP.
>> Microsoft SQL Server 7.00 - 7.00.842.
>> The problem is that there is a backup-process that is
>> runnable but wont finish or timeout. When i am trying to
>> kill the process nothing happens. It is still there!?!
>> Can someone maybe give some pointers to what i should do
>> to get ride of this process.
>> As it is now i cannot take a backup of the database the
>> backup process is hanged on.
>> /Risun
>
>.
>|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx.gbl...
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
> >--Original Message--
> >Hi,
> >
> >From the SQL Server machine, Open Query Analyzer and
> execute the below
> >comamnd and see whether it suceeds.
> >Ensure that an existing Backup process is not going on.
> >
> >BACKUP database <dbname> to disk='d:\backup\dbname.bak'
> with init , stats=10
> >
> >Init parameter will overwrite the backup filr every time
> and stats=10 , will
> >show the percentage completed.
> >
> >Note:
> >
> >See the CPU and Memory usage of server.
> >
> >--
> >Thanks
> >Hari
> >MCDBA
> >"Risun" <risun@.wmdata.com> wrote in message
> >news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> >> Hi everybody
> >>
> >> OS is Win2000 with latest SP.
> >> Microsoft SQL Server 7.00 - 7.00.842.
> >>
> >> The problem is that there is a backup-process that is
> >> runnable but wont finish or timeout. When i am trying to
> >> kill the process nothing happens. It is still there!?!
> >>
> >> Can someone maybe give some pointers to what i should do
> >> to get ride of this process.
> >> As it is now i cannot take a backup of the database the
> >> backup process is hanged on.
> >>
> >> /Risun
> >
> >
> >.
> >
Subscribe to:
Posts (Atom)