I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
MarkOptimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
Showing posts with label master. Show all posts
Showing posts with label master. Show all posts
Saturday, February 25, 2012
Maintenance Plans - Master, MSDB, etc.
I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
Mark
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
Mark
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
Maintenance Plans - Master, MSDB, etc.
I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
MarkOptimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
MarkOptimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
Monday, February 20, 2012
Maintenance Plan,SQL Server 2000
Hi,
I set up a scheduled Maintenance Plan for DB backups. For some reason just user DBs backups are performed. For master and msdb I can run backups manually via T-SQL or Enterprise Mngr and do not have any problems. But it doesn't work with Maint. Plan. There are no any error messages in SQL error log, the only error message I can see comes from View Job History(SQL Server Agent, Jobs) and says 'job failed'.
I administrate several servers and never had this kind of problem.
I logged as 'sa' .
Any ideas?
I appreciate all your help.:confused:Any chance you can post the command(s) you are using to backup your user and system dbs?|||Thank you for your response. I've fixed the problem - it was a security issue for the NT account on master & msdb files.
Thanx again
I set up a scheduled Maintenance Plan for DB backups. For some reason just user DBs backups are performed. For master and msdb I can run backups manually via T-SQL or Enterprise Mngr and do not have any problems. But it doesn't work with Maint. Plan. There are no any error messages in SQL error log, the only error message I can see comes from View Job History(SQL Server Agent, Jobs) and says 'job failed'.
I administrate several servers and never had this kind of problem.
I logged as 'sa' .
Any ideas?
I appreciate all your help.:confused:Any chance you can post the command(s) you are using to backup your user and system dbs?|||Thank you for your response. I've fixed the problem - it was a security issue for the NT account on master & msdb files.
Thanx again
Subscribe to:
Posts (Atom)