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 online. Show all posts
Showing posts with label online. 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.
>
>
Thursday, March 8, 2012
Backup permission
Hello,
I=B4ve some SQL Server databases that the backups are being=20
made with integration of the Omniback Online Agent for SQL=20
Server. At this moment i=B4ve one user configured for this=20
integration and everything goes fine but the problem is=20
that this user have 'Sysadmin' permissions, if i remove=20
the user from the sysadmin in sql server i can do it if i=20
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the=20
permissions of this user and if i give(put) this user in=20
the db_backupoperator database role, that is suposed to=20
work, when running the backup the report shows 0(zero)KB=20
done.
How can i resolve this issue? I really need to limit the=20
access of this user for security and administration=20
pruposes.
Best Regards
You can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards
|||No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards
|||Thanks Tibor,
I use this text to put one post in HP forums but got no=20
answer.
Other thing that i dont understand is that when a user is=20
member of the db_backupoperator and use this user to=20
register in Enterprise Manager(to test backups), when i=20
need to choose the location for the backup the following=20
error appear (ERROR 229: Execution permissions denied=20
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few=20
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be=20
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--=20
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> 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
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx.gbl...
> Hello,
> Ive some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment ive one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>
|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>Ive some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment ive one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
I=B4ve some SQL Server databases that the backups are being=20
made with integration of the Omniback Online Agent for SQL=20
Server. At this moment i=B4ve one user configured for this=20
integration and everything goes fine but the problem is=20
that this user have 'Sysadmin' permissions, if i remove=20
the user from the sysadmin in sql server i can do it if i=20
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the=20
permissions of this user and if i give(put) this user in=20
the db_backupoperator database role, that is suposed to=20
work, when running the backup the report shows 0(zero)KB=20
done.
How can i resolve this issue? I really need to limit the=20
access of this user for security and administration=20
pruposes.
Best Regards
You can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards
|||No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards
|||Thanks Tibor,
I use this text to put one post in HP forums but got no=20
answer.
Other thing that i dont understand is that when a user is=20
member of the db_backupoperator and use this user to=20
register in Enterprise Manager(to test backups), when i=20
need to choose the location for the backup the following=20
error appear (ERROR 229: Execution permissions denied=20
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few=20
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be=20
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--=20
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> 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
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx.gbl...
> Hello,
> Ive some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment ive one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>
|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>Ive some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment ive one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
Backup permission
Hello,
I=B4ve some SQL Server databases that the backups are being made with integration of the Omniback Online Agent for SQL Server. At this moment i=B4ve one user configured for this integration and everything goes fine but the problem is that this user have 'Sysadmin' permissions, if i remove the user from the sysadmin in sql server i can do it if i give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the permissions of this user and if i give(put) this user in the db_backupoperator database role, that is suposed to work, when running the backup the report shows 0(zero)KB done.
How can i resolve this issue? I really need to limit the access of this user for security and administration pruposes.
Best RegardsYou can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
--
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
I´ve some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment i´ve one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
I´ve some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment i´ve one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||Thanks Tibor,
I use this text to put one post in HP forums but got no answer.
Other thing that i dont understand is that when a user is member of the db_backupoperator and use this user to register in Enterprise Manager(to test backups), when i need to choose the location for the backup the following error appear (ERROR 229: Execution permissions denied on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>-- >Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> 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
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx.gbl...
> Hello,
> I´ve some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment i´ve one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
--
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>I´ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i´ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
I=B4ve some SQL Server databases that the backups are being made with integration of the Omniback Online Agent for SQL Server. At this moment i=B4ve one user configured for this integration and everything goes fine but the problem is that this user have 'Sysadmin' permissions, if i remove the user from the sysadmin in sql server i can do it if i give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the permissions of this user and if i give(put) this user in the db_backupoperator database role, that is suposed to work, when running the backup the report shows 0(zero)KB done.
How can i resolve this issue? I really need to limit the access of this user for security and administration pruposes.
Best RegardsYou can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
--
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
I´ve some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment i´ve one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
Hello,
I´ve some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment i´ve one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||Thanks Tibor,
I use this text to put one post in HP forums but got no answer.
Other thing that i dont understand is that when a user is member of the db_backupoperator and use this user to register in Enterprise Manager(to test backups), when i need to choose the location for the backup the following error appear (ERROR 229: Execution permissions denied on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>-- >Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> 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
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx.gbl...
> Hello,
> I´ve some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment i´ve one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
--
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx.gbl...
>Hello,
>I´ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i´ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
Backup permission
Hello,
I=B4ve some SQL Server databases that the backups are being=20
made with integration of the Omniback Online Agent for SQL=20
Server. At this moment i=B4ve one user configured for this=20
integration and everything goes fine but the problem is=20
that this user have 'Sysadmin' permissions, if i remove=20
the user from the sysadmin in sql server i can do it if i=20
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the=20
permissions of this user and if i give(put) this user in=20
the db_backupoperator database role, that is suposed to=20
work, when running the backup the report shows 0(zero)KB=20
done.
How can i resolve this issue? I really need to limit the=20
access of this user for security and administration=20
pruposes.
Best RegardsYou can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||No need to start a new thread for this. I replied a few days ago that you ne
ed to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring th
e fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c
44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||Thanks Tibor,
I use this text to put one post in HP forums but got no=20
answer.
Other thing that i dont understand is that when a user is=20
member of the db_backupoperator and use this user to=20
register in Enterprise Manager(to test backups), when i=20
need to choose the location for the backup the following=20
error appear (ERROR 229: Execution permissions denied=20
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few=20
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be=20
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--=20
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> 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
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
> Hello,
> Ive some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment ive one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx
.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
>Hello,
>Ive some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment ive one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
I=B4ve some SQL Server databases that the backups are being=20
made with integration of the Omniback Online Agent for SQL=20
Server. At this moment i=B4ve one user configured for this=20
integration and everything goes fine but the problem is=20
that this user have 'Sysadmin' permissions, if i remove=20
the user from the sysadmin in sql server i can do it if i=20
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the=20
permissions of this user and if i give(put) this user in=20
the db_backupoperator database role, that is suposed to=20
work, when running the backup the report shows 0(zero)KB=20
done.
How can i resolve this issue? I really need to limit the=20
access of this user for security and administration=20
pruposes.
Best RegardsYou can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||No need to start a new thread for this. I replied a few days ago that you ne
ed to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring th
e fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c
44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||Thanks Tibor,
I use this text to put one post in HP forums but got no=20
answer.
Other thing that i dont understand is that when a user is=20
member of the db_backupoperator and use this user to=20
register in Enterprise Manager(to test backups), when i=20
need to choose the location for the backup the following=20
error appear (ERROR 229: Execution permissions denied=20
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few=20
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be=20
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--=20
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> 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
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
> Hello,
> Ive some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment ive one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
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
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx
.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything
>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
>Hello,
>Ive some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment ive one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>
Subscribe to:
Posts (Atom)