Thursday, March 29, 2012
Estimating Log File Size
Yesterday I was given a sp to calculate the size of tables
and the overall size of data files.
Is there something similar for log files, i.e. an
algorithm to calculate the size now and say 2 years time
of a log file ?
Thanks
Jim
Jimbo
Look at sp_helpfile as well as sysfiles system table
It is hard to estimate what is your log file will be in the next two years.
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> Dear All,
> Yesterday I was given a sp to calculate the size of tables
> and the overall size of data files.
> Is there something similar for log files, i.e. an
> algorithm to calculate the size now and say 2 years time
> of a log file ?
> Thanks
> Jim
|||Probably the best way to estimate future sizes is to capture growth over
time and predict from that...
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
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> Dear All,
> Yesterday I was given a sp to calculate the size of tables
> and the overall size of data files.
> Is there something similar for log files, i.e. an
> algorithm to calculate the size now and say 2 years time
> of a log file ?
> Thanks
> Jim
|||Hi,
You could also use the below command to get current log size and usage
dbcc sqlperf(logspace)
Estimating the log size for next 2 years will be hard.. That depends up on
the amount of batch operation and frequency in which
you perform the transaction log backup. Normally it is not required to
project Log size because the log file will be cleared once
you perform the transaction log backup.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eFgFomsfEHA.3932@.TK2MSFTNGP09.phx.gbl...
> Jimbo
> Look at sp_helpfile as well as sysfiles system table
> It is hard to estimate what is your log file will be in the next two
years.
>
> "Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
> news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
>
Estimating Log File Size
Yesterday I was given a sp to calculate the size of tables
and the overall size of data files.
Is there something similar for log files, i.e. an
algorithm to calculate the size now and say 2 years time
of a log file ?
Thanks
JimJimbo
Look at sp_helpfile as well as sysfiles system table
It is hard to estimate what is your log file will be in the next two years.
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> Dear All,
> Yesterday I was given a sp to calculate the size of tables
> and the overall size of data files.
> Is there something similar for log files, i.e. an
> algorithm to calculate the size now and say 2 years time
> of a log file ?
> Thanks
> Jim|||Probably the best way to estimate future sizes is to capture growth over
time and predict from that...
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
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> Dear All,
> Yesterday I was given a sp to calculate the size of tables
> and the overall size of data files.
> Is there something similar for log files, i.e. an
> algorithm to calculate the size now and say 2 years time
> of a log file ?
> Thanks
> Jim|||Hi,
You could also use the below command to get current log size and usage
dbcc sqlperf(logspace)
Estimating the log size for next 2 years will be hard.. That depends up on
the amount of batch operation and frequency in which
you perform the transaction log backup. Normally it is not required to
project Log size because the log file will be cleared once
you perform the transaction log backup.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eFgFomsfEHA.3932@.TK2MSFTNGP09.phx.gbl...
> Jimbo
> Look at sp_helpfile as well as sysfiles system table
> It is hard to estimate what is your log file will be in the next two
years.
>
> "Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
> news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
>
Estimating Log File Size
Yesterday I was given a sp to calculate the size of tables
and the overall size of data files.
Is there something similar for log files, i.e. an
algorithm to calculate the size now and say 2 years time
of a log file ?
Thanks
JimJimbo
Look at sp_helpfile as well as sysfiles system table
It is hard to estimate what is your log file will be in the next two years.
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> Dear All,
> Yesterday I was given a sp to calculate the size of tables
> and the overall size of data files.
> Is there something similar for log files, i.e. an
> algorithm to calculate the size now and say 2 years time
> of a log file ?
> Thanks
> Jim|||Probably the best way to estimate future sizes is to capture growth over
time and predict from that...
--
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
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> Dear All,
> Yesterday I was given a sp to calculate the size of tables
> and the overall size of data files.
> Is there something similar for log files, i.e. an
> algorithm to calculate the size now and say 2 years time
> of a log file ?
> Thanks
> Jim|||Hi,
You could also use the below command to get current log size and usage
dbcc sqlperf(logspace)
Estimating the log size for next 2 years will be hard.. That depends up on
the amount of batch operation and frequency in which
you perform the transaction log backup. Normally it is not required to
project Log size because the log file will be cleared once
you perform the transaction log backup.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eFgFomsfEHA.3932@.TK2MSFTNGP09.phx.gbl...
> Jimbo
> Look at sp_helpfile as well as sysfiles system table
> It is hard to estimate what is your log file will be in the next two
years.
>
> "Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
> news:33ff01c47ec6$197af750$a501280a@.phx.gbl...
> > Dear All,
> >
> > Yesterday I was given a sp to calculate the size of tables
> > and the overall size of data files.
> >
> > Is there something similar for log files, i.e. an
> > algorithm to calculate the size now and say 2 years time
> > of a log file ?
> >
> > Thanks
> > Jim
>
Tuesday, March 27, 2012
estimate of transaction log size for reindexing
Is there anyway to estimate the transaction log files needed to reindex all
tables in a database?
I mean any formula that can be used?
regards,
meLook at how big your indexes are now. this is different depending on the
version of sql server you are on. tlog will vary depending on this size and
the type of defrag operation done.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:FF5149C0-A8B3-4B34-BFE3-D18A7E2ED15E@.microsoft.com...
> Hello,
> Is there anyway to estimate the transaction log files needed to reindex
> all
> tables in a database?
> I mean any formula that can be used?
> regards,
> me|||Hi
You have to identify what tables are defragmented and run rebuild index only
on them. Please tell us what SQL Server you are using?
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:FF5149C0-A8B3-4B34-BFE3-D18A7E2ED15E@.microsoft.com...
> Hello,
> Is there anyway to estimate the transaction log files needed to reindex
> all
> tables in a database?
> I mean any formula that can be used?
> regards,
> mesql
Estimate Log Space for Alter Table Statement
My client's website database is hosted by a third party. I need to alter one of the column definitions for the largest table in the database. Unfortunately, the transaction log fills up if I try to alter the table. I've done all the usual stuff like truncating the log, etc., but the simple fact is that the operation requires more log space than we have available. Therefore, we need to purchase additional disk space for the database.
What I'm looking for is a way to roughly estimate how much log space will be required to alter this table so that we purchase enough but not too much additional space. The table has an identity primary key and 4 other single column indexes: one int, one datetime and two varchar(30) columns.
Any suggestions? Thanks in advance.
You can change the truncate log setting in a database if you don't need it to recover in time of emergency it is a very complicated subject so run a search for truncate log on checkpoint option for your database setting in the BOL(books online). The links below are basic guidelines from Microsoft. Hope this helps.
http://support.microsoft.com/kb/873235
http://msdn2.microsoft.com/en-us/library/aa933068(SQL.80).aspx
|||If I remember correctly when you alter column in table, SQL server renames old one, created new table with new structure and next moves data into new table. So in your case you need at least amount of space your data table takes for log because all process has to be done at one shot.
But maybe you can do it yourself: create table with new structure and move data from old table to new table with quantity like 100 or 1000 records in one shot? Log file will be small and you should succeed. You only have to take care about identity insert if you have one in your table.
Thanks
|||Thanks jpazgier, that's a great suggestion! I usually do the alter using Enterprise Manager directly for this client but I have scripted this type of change for other clients. I never thought about taking the generated script and breaking up the insert part of it into multiple inserts and performing the truncate log after each insert. That would reduce the log space required.
If I don't delete the old records as I go, I still need twice the data just for the old and new copies but I wouldn't need so much log space. If I trust my alterations, then I could delete the old records as they get moved into the new copy and really reduce the free space required. Not as safe but probably sufficient.
Thanks
|||(1) You could keep the DB in simple mode while you do the data transfer.
(2) You can also have a job running to truncate the log during the transfer and let the job run every 1 minute, so you dont have to do it yourself manually.
(3) You can use bcp/Bulk Insert to transfer the data.
Monday, March 26, 2012
Establish log dhipping db in sql2005
I have db on my log shipping server as standby\readonly and my transaction log
was out of sync, I would like to make full bak from the source server and
restore
on log shipping server but when I right click the db in sql manager studio
the RESTORE database option DIM out. I can do this with sql 2000 to
reestablish
db when my transaction log was out of sync but look like I can't do this
with sql 2005. Have i missed any thing here?
Please help
Thanks in advancedfrank
Personally I have not played yet with it on SQL Server 2005 , but can you
issue BACKUP/RESTORE in the query builder instead of SSMS?
"frank" <frank@.discussions.microsoft.com> wrote in message
news:752AC215-1833-4B97-B57C-2E52C646D6BF@.microsoft.com...
> Hi all
> I have db on my log shipping server as standby\readonly and my transaction
> log
> was out of sync, I would like to make full bak from the source server and
> restore
> on log shipping server but when I right click the db in sql manager studio
> the RESTORE database option DIM out. I can do this with sql 2000 to
> reestablish
> db when my transaction log was out of sync but look like I can't do this
> with sql 2005. Have i missed any thing here?
> Please help
> Thanks in advanced
Establish log dhipping db in sql2005
I have db on my log shipping server as standby\readonly and my transaction log
was out of sync, I would like to make full bak from the source server and
restore
on log shipping server but when I right click the db in sql manager studio
the RESTORE database option DIM out. I can do this with sql 2000 to
reestablish
db when my transaction log was out of sync but look like I can't do this
with sql 2005. Have i missed any thing here?
Please help
Thanks in advanced
frank
Personally I have not played yet with it on SQL Server 2005 , but can you
issue BACKUP/RESTORE in the query builder instead of SSMS?
"frank" <frank@.discussions.microsoft.com> wrote in message
news:752AC215-1833-4B97-B57C-2E52C646D6BF@.microsoft.com...
> Hi all
> I have db on my log shipping server as standby\readonly and my transaction
> log
> was out of sync, I would like to make full bak from the source server and
> restore
> on log shipping server but when I right click the db in sql manager studio
> the RESTORE database option DIM out. I can do this with sql 2000 to
> reestablish
> db when my transaction log was out of sync but look like I can't do this
> with sql 2005. Have i missed any thing here?
> Please help
> Thanks in advanced
Establish log dhipping db in sql2005
I have db on my log shipping server as standby\readonly and my transaction l
og
was out of sync, I would like to make full bak from the source server and
restore
on log shipping server but when I right click the db in sql manager studio
the RESTORE database option DIM out. I can do this with sql 2000 to
reestablish
db when my transaction log was out of sync but look like I can't do this
with sql 2005. Have i missed any thing here?
Please help
Thanks in advancedfrank
Personally I have not played yet with it on SQL Server 2005 , but can you
issue BACKUP/RESTORE in the query builder instead of SSMS?
"frank" <frank@.discussions.microsoft.com> wrote in message
news:752AC215-1833-4B97-B57C-2E52C646D6BF@.microsoft.com...
> Hi all
> I have db on my log shipping server as standby\readonly and my transaction
> log
> was out of sync, I would like to make full bak from the source server and
> restore
> on log shipping server but when I right click the db in sql manager studio
> the RESTORE database option DIM out. I can do this with sql 2000 to
> reestablish
> db when my transaction log was out of sync but look like I can't do this
> with sql 2005. Have i missed any thing here?
> Please help
> Thanks in advanced
Wednesday, March 21, 2012
Errors while running SQLH2 Tool
can you advice how can i resolve them
Errors:
1.InvalidOperationException Cannot read log entry number 4243737.
2.NullReferenceException Object reference not set to an instance of an
object.
3.Event Log There is no gap in history, but the
previous last event
is out of bounds
What version of SQLH2 are you running? I hope it's updated version
(2.0.024).
1. Quote from SQLH2 V2 Deployment Guide
Cannot read log entry number ###.
This error usually indicates that the event log on the target machine is
corrupted. It's easy to verify using Event Viewer - try to open the
suspected event log and check if you can read events from it (sometimes
Event Viewer is able to show the list of events, but an actual attempt to
read some events fails).
I would need more inofmation regarding the other two.
Please send a mail to SQLH2@.microsoft.com
(with your H2log.txt attached).
Thanks
Grigory
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Aneel Ismaily" <Aneel Ismaily@.discussions.microsoft.com> wrote in message
news:A219CD0B-C253-43E2-90E2-487CE248BAF3@.microsoft.com...
> I am recieving following errors while running SQLH2
> can you advice how can i resolve them
> Errors:
> 1.InvalidOperationException Cannot read log entry number 4243737.
> 2.NullReferenceException Object reference not set to an instance of
an
> object.
> 3.Event Log There is no gap in history, but the
> previous last event
> is out of bounds
>
errors whan running backup plan
day)
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels Backup
Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by Schedule
20 (Schedule 1). The last step to run was step 1 (Step 1).
That error message follows four other entries like this.
Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump devices:
1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
I seem to have all the backups in the folder that there should be, but then what
is happening with the first error message?
I also can manually make a backup without any error messages appearing so
something is wrong with my plan but what? it doesn't look that complicated to
set up.Do you have any other steps on this maintenance plan such as an integrity
check?
Jim
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
> Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Do you get any better errormessages if you specify a report file for the
plan and check that report file?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
> Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Ahh that was helpful.
here is what I get:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
...
So I removed the system databases leaving only my database from the backup
and it went fine. do I need to save the system databases differently? or at
all?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Do you get any better errormessages if you specify a report file for the
> plan and check that report file?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "mmac" <mmac@.junkmail.bin> wrote in message
> news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > My event log has the following entries every day ( because the plan runs
> every
> > day)
> >
> > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
'Michaels
> Backup
> > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
on:
> > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> Schedule
> > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> >
> > That error message follows four other entries like this.
> >
> > Database backed up: Database: model, creation date(time):
> 2000/08/06(01:40:52),
> > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> devices:
> > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
> SQL
> > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> >
> > I seem to have all the backups in the folder that there should be, but
> then what
> > is happening with the first error message?
> > I also can manually make a backup without any error messages appearing
so
> > something is wrong with my plan but what? it doesn't look that
complicated
> to
> > set up.
> >
> >
>|||> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
Yes, create a different maint pan for master, model and msdb and do backup
once a day... :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <no@.thanks.com> wrote in message
news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> Ahh that was helpful.
> here is what I get:
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
> 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs
to
> be in single user mode.
> ...
> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > Do you get any better errormessages if you specify a report file for the
> > plan and check that report file?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "mmac" <mmac@.junkmail.bin> wrote in message
> > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > My event log has the following entries every day ( because the plan
runs
> > every
> > > day)
> > >
> > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> 'Michaels
> > Backup
> > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
> on:
> > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> > Schedule
> > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > >
> > > That error message follows four other entries like this.
> > >
> > > Database backed up: Database: model, creation date(time):
> > 2000/08/06(01:40:52),
> > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> > devices:
> > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
Files\Microsoft
> > SQL
> > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > >
> > > I seem to have all the backups in the folder that there should be, but
> > then what
> > > is happening with the first error message?
> > > I also can manually make a backup without any error messages appearing
> so
> > > something is wrong with my plan but what? it doesn't look that
> complicated
> > to
> > > set up.
> > >
> > >
> >
> >
>|||and they will backup in "single user mode"?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> > So I removed the system databases leaving only my database from the
> backup
> > and it went fine. do I need to save the system databases differently? or
> at
> > all?
> Yes, create a different maint pan for master, model and msdb and do backup
> once a day... :-)
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "mmac" <no@.thanks.com> wrote in message
> news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > Ahh that was helpful.
> > here is what I get:
> >
> >
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> > 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> > Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
> > 'MASTER'.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> > [1] Database master: Check Data and Index Linkage...
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Repair statement not processed. Database needs
> to
> > be in single user mode.
> > ...
> > So I removed the system databases leaving only my database from the
> backup
> > and it went fine. do I need to save the system databases differently? or
> at
> > all?
> >
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > Do you get any better errormessages if you specify a report file for the
> > > plan and check that report file?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at:
> > >
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > >
> > >
> > > "mmac" <mmac@.junkmail.bin> wrote in message
> > > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > > My event log has the following entries every day ( because the plan
> runs
> > > every
> > > > day)
> > > >
> > > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > 'Michaels
> > > Backup
> > > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
> > on:
> > > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> > > Schedule
> > > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > > >
> > > > That error message follows four other entries like this.
> > > >
> > > > Database backed up: Database: model, creation date(time):
> > > 2000/08/06(01:40:52),
> > > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> > > devices:
> > > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
> Files\Microsoft
> > > SQL
> > > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > > >
> > > > I seem to have all the backups in the folder that there should be, but
> > > then what
> > > > is happening with the first error message?
> > > > I also can manually make a backup without any error messages appearing
> > so
> > > > something is wrong with my plan but what? it doesn't look that
> > complicated
> > > to
> > > > set up.
> > > >
> > > >
> > >
> > >
> >
> >
>|||There's no need to set the single user mode unless you check the dreaded
"Attempt to repair minor problems" under the integrity check part. I do not
recommend using this option at all. If I have a problem with a corrupt
database, I want to know that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:uy7MGro$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> and they will backup in "single user mode"?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> > > So I removed the system databases leaving only my database from the
> > backup
> > > and it went fine. do I need to save the system databases differently?
or
> > at
> > > all?
> >
> > Yes, create a different maint pan for master, model and msdb and do
backup
> > once a day... :-)
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "mmac" <no@.thanks.com> wrote in message
> > news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > > Ahh that was helpful.
> > > here is what I get:
> > >
> > >
> > > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server
> > > 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> > > Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30
PM
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
database
> > > 'MASTER'.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
failed.
> > > [1] Database master: Check Data and Index Linkage...
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Repair statement not processed. Database
needs
> > to
> > > be in single user mode.
> > > ...
> > > So I removed the system databases leaving only my database from the
> > backup
> > > and it went fine. do I need to save the system databases differently?
or
> > at
> > > all?
> > >
> > >
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in
> > > message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > > Do you get any better errormessages if you specify a report file for
the
> > > > plan and check that report file?
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at:
> > > >
> > >
> >
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > > >
> > > >
> > > > "mmac" <mmac@.junkmail.bin> wrote in message
> > > > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > > > My event log has the following entries every day ( because the
plan
> > runs
> > > > every
> > > > > day)
> > > > >
> > > > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > > 'Michaels
> > > > Backup
> > > > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed -
Invoked
> > > on:
> > > > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked
by
> > > > Schedule
> > > > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > > > >
> > > > > That error message follows four other entries like this.
> > > > >
> > > > > Database backed up: Database: model, creation date(time):
> > > > 2000/08/06(01:40:52),
> > > > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of
dump
> > > > devices:
> > > > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
> > Files\Microsoft
> > > > SQL
> > > > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > > > >
> > > > > I seem to have all the backups in the folder that there should be,
but
> > > > then what
> > > > > is happening with the first error message?
> > > > > I also can manually make a backup without any error messages
appearing
> > > so
> > > > > something is wrong with my plan but what? it doesn't look that
> > > complicated
> > > > to
> > > > > set up.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
errors whan running backup plan
ry
day)
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels Ba
ckup
Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by Schedu
le
20 (Schedule 1). The last step to run was step 1 (Step 1).
That error message follows four other entries like this.
Database backed up: Database: model, creation date(time): 2000/08/06(01:40:5
2),
pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump device
s:
1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
Server\MSSQL\BACKUP\model_db_20040211020
0.BAK'}).
I seem to have all the backups in the folder that there should be, but then
what
is happening with the first error message?
I also can manually make a backup without any error messages appearing so
something is wrong with my plan but what? it doesn't look that complicated t
o
set up.Do you have any other steps on this maintenance plan such as an integrity
check?
Jim
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft[/colo
r]
SQL
> Server\MSSQL\BACKUP\model_db_20040211020
0.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Do you get any better errormessages if you specify a report file for the
plan and check that report file?
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft[/colo
r]
SQL
> Server\MSSQL\BACKUP\model_db_20040211020
0.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Ahh that was helpful.
here is what I get:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft]
91;ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
...
So I removed the system databases leaving only my database from the backup
and it went fine. do I need to save the system databases differently? or at
all?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Do you get any better errormessages if you specify a report file for the
> plan and check that report file?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "mmac" <mmac@.junkmail.bin> wrote in message
> news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> every
'Michaels
> Backup
on:
> Schedule
> 2000/08/06(01:40:52),
> devices:
> SQL
> then what
so
complicated
> to
>|||> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
Yes, create a different maint pan for master, model and msdb and do backup
once a day... :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"mmac" <no@.thanks.com> wrote in message
news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> Ahh that was helpful.
> here is what I get:
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODB
C
SQL
> Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in databa
se
> 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODB
C
SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs[/colo
r]
to
> be in single user mode.
> ...
> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
>
http://groups.google.com/groups?oi=...ublic.sqlserver
runs
> 'Michaels
> on:
Files\Microsoft
> so
> complicated
>|||and they will backup in "single user mode"?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> backup
> at
> Yes, create a different maint pan for master, model and msdb and do backup
> once a day... :-)
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
>
> "mmac" <no@.thanks.com> wrote in message
> news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> SQL
> SQL
> to
> backup
> at
> in
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
> runs
> Files\Microsoft
>|||There's no need to set the single user mode unless you check the dreaded
"Attempt to repair minor problems" under the integrity check part. I do not
recommend using this option at all. If I have a problem with a corrupt
database, I want to know that.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:uy7MGro$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> and they will backup in "single user mode"?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
or
backup
http://groups.google.com/groups?oi=...ublic.sqlserver
Server
PM
[Microsoft][ODBC
database
failed.
[Microsoft][ODBC
needs
or
wrote
the
http://groups.google.com/groups?oi=...ublic.sqlserver
plan
Invoked
by
dump
but
appearing
>
errors using BPA
I am trying to run the best practices analyzer and am getting some time
out errors. Attached is the log. Any help would be greatly appreciated.
Log:
//--
Best Practice log file created at 12/22/2004 10:46:18 AM
Job name: Test
Log file: c:\program files\microsoft sql server best practices
analyzer\log\Test_comp-l-db_0001_comp-L-DB%DBServer_SQLBestPA.log
//--
Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
Getting affinity mask setting... BPAffinityMask.Execute()
Complied ... in BPAffinityMask.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffin ityMask
Preparing rule... Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.BPAllo wUpdate
Getting 'allow update' information... BPAllowUpdate.Execute()
Complied ... in BPAllowUpdate.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.B PAllowUpdate
Preparing rule... Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAutoStat s
Getting AUTO_STAT information for each database... BPAutoStats.Execute()
Complied ... in BPAutoStats.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAut oStats
Preparing rule...
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad
Getting objects information
...Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad .BpCreateDatabaseForLoad.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoa d.BpCreateDatabaseForLoad
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate
Getting objects information
...Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCur sorForUpdate.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCu rsorForUpdate
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es
Getting objects information
...Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursor Usages.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCursorUsages.BpCurso rUsages
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLevel
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLe vel
Preparing rule...
Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
Getting machine name and list of databases ... BpFileCompression.Execute()
Complied ... in BpFileCompression.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDBBacku ps
Getting database names ... BPDBBackups.Execute()
Getting readonly state and backup infor for each database ...
BPDBBackups.Execute()
Partially Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDB Backups
Preparing rule... Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPMsMSDB Backup
master: Database has been backed up in the specified period.
msdb: Database has been backed up in the specified period.
Complied ... in BPMsMSDBBackup.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPM sMSDBBackup
Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
Getting current date ... BPNoLogBackup.Execute()
Getting machine name and server instance ... BPNoLogBackup.Execute()
Getting info from NT Event Log ... BPNoLogBackup.Execute()
Complied ... in BPNoLogBackup.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.BPDbSQ LOptions
Getting databases and SQL option settings... BPDbSQLOptions.Execute()
Partially Complied ... in BPDbSQLOptions.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.B PDbSQLOptions
Preparing rule... Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefaultsR ules
Not Complied ... in BpDefaultsRules.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefa ultsRules
Preparing rule... Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP
Getting objects information
...Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprec atedSP.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepre catedSP
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpDatabaseFilePlacement.BPD BFilePlacement
Getting all DB Names... BPDBFilePlacement.Execute()
Getting file placement information... BPDBFilePlacement.Execute()
Partially Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseFilePlacemen t.BPDBFilePlacement
Preparing rule... Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull
Getting objects information
...Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNu ll.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsN ull
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
Getting machine and instance name... BPNoLogBackup.Execute()
Getting error log path... BPNoLogBackup.Execute()
Getting log size ... BPNoLogBackup.Execute()
Complied ... in BPFailedBackupEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
Preparing rule... Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias
Getting objects information
...Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExp ressionAlias.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpExpressionAlias.BpEx pressionAlias
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
Getting current date ... BPFailedBackupEvent.Execute()
Getting machine name and server instance ... BPFailedBackupEvent.Execute()
Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
Complied ... in BPFailedBackupEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
Preparing rule... Microsoft.SqlBpa.Rules.BPFibers.BPFibers
Getting lightweight pooling setting... BPFibers.Execute()
Complied ... in BPFibers.Execute()
Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BPFibers.BPFibers
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized
Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
Complied ... in BPFTBackgroundServicesOptimized.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOptimized
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBlobExtensionType.BPFTB lobExtension
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBlobExtensionType. BPFTBlobExtension
Preparing rule... Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPFTCata logs
Getting all databases... BPFTCatalogs.Execute()
Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPF TCatalogs
Preparing rule...
Microsoft.SqlBpa.Rules.BpFullTextCatalogPlacement. BPFullTextCatPlacement
Getting all databases... BPFullTextCatPlacement.Execute()
Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogPlace ment.BPFullTextCatPlacement
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnabled.B PFTChangeTracking
Getting databases... BPFTChangeTracking.Execute()
Complied ... in BPFTChangeTracking.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnab led.BPFTChangeTracking
Preparing rule... Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate
Getting objects information
...Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupli cate.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupl icate
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
Getting machine name ... BPFTMSSearchLocalSystem.Execute()
Complied ... in BPFTMSSearchLocalSystem.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
Getting machine name... BPFTPropertyStore.Execute()
Complied ... in BPFTPropertyStore.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
Preparing rule...
Microsoft.SqlBpa.Rules.BpFullTextIndexedTimestampC olumn.BPFTIndexedTimestampColumn
Complied ... in BPFTIndexedTimestampColumn.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextIndexedTimes tampColumn.BPFTIndexedTimestampColumn
Preparing rule...
Microsoft.SqlBpa.Rules.BpIndexDefragmentation.BPIn dexDefrag
Getting database names ... BPIndexDefrag.Execute()
Complied ... in BPIndexDefrag.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpIndexDefragmentation .BPIndexDefrag
Preparing rule... Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType
Getting objects information
...Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpIndexType.BpIndexTyp e
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List
Getting objects information
...Microsoft.SqlBpa.Rules.BpInsertColList.BpInser tColList.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpInsertColList.BpInse rtColList
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpInvalidUserTables.BpInval idUserTables
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpInvalidUserTables.Bp InvalidUserTables
Preparing rule...
Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.BPFixe dLogGrowth
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.B PFixedLogGrowth
Preparing rule... Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMaxServ erMem
Getting config values... BPMaxServerMem.Execute()
Getting all databases & full-text enabled status ...
BPMaxServerMem.Execute()
Not Complied ... in BPMaxServerMem.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMa xServerMem
Preparing rule... Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er
Getting objects information
...Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAns iOuter.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAn siOuter
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
Not Complied ... in NoPk.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
Preparing rule... Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuil tins.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBui ltins
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Exe cute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Execute ()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSys Tables.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSy sTables
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals
Getting objects information
...Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrd erByOrdinals.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOr derByOrdinals
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BPDBDis kSpace
Checking db size... BPDBDiskSpace.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BP DBDiskSpace
Preparing rule...
Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled.BPPr iorityBoost
Getting 'priority boost' information... BPPriorityBoost.Execute()
Not Complied ... in BPPriorityBoost.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled .BPPriorityBoost
Preparing rule... Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames
Getting objects information
...Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQual ifiedNames.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQua lifiedNames
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPRecInt erval
Getting current recovery interval setting... BPRecInterval.Execute()
Complied ... in BPRecInterval.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPR ecInterval
Preparing rule... Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPReuseBk upFile
Getting readonly state and backup info for each database ...
BPReuseBackupFile.Execute()
Complied ... in BPReuseBackupFile.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPRe useBkupFile
Preparing rule...
Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.BPRecM odelUsage
Getting database names ... BPRecModelUsage.Execute()
Partially Complied ... in BPRecModelUsage.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.B PRecModelUsage
Preparing rule...
Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
Getting current date, machine name, and instance name ...
BPSevereErrorEvent.Execute()
Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
Complied ... in BPSevereErrorEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
Preparing rule... Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
Getting objects information
...Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Exe cute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Execute ()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSize.BP SetWorkingSetSize
Getting config values... BPSetWorkingSetSize.Execute()
Complied ... in BPSetWorkingSetSize.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSi ze.BPSetWorkingSetSize
Preparing rule... Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
Getting objects information
...Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.E xecute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Execu te()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
Getting current date, machine name, and instance name ...
BPUnexpectedShutdown.Execute()
Getting startup and shutdown info from NT Event Log ...
BPUnexpectedShutdown.Execute()
Identifying possible undexpected shutdowns ...
BPUnexpectedShutdown.Execute()
Retrieveing possible begin time for unexpected shutdown prior to startup ...
BPUnexpectedShutdown.Execute()
Complied ... in BPUnexpectedShutdown.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
Preparing rule... Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure
Getting objects information
...Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfi gure.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConf igure
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption
Getting objects information
...Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpti on.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpt ion
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpStar.BpStar
Getting objects information
...Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BpStar.BpStar
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNullServername.BPNullServ er
Getting @.@.servername... BPNullServer.Execute()
Complied ... in BPNullServer.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNullServername.BPNul lServer
Preparing rule... Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BPTempD BSize
Complied ... in BPTempDBSize.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BP TempDBSize
Preparing rule... Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables
Getting objects information
...Microsoft.SqlBpa.Rules.BpTempTables.BpTempTabl es.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTempTables.BpTempTab les
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By
Getting objects information
...Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoO rderBy.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNo OrderBy
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerNested.BpTrig gerNested
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
Getting objects information
...Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTrig gerNoCount.Execute()
Not Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTri ggerNoCount
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
Getting objects information
...Microsoft.SqlBpa.Rules.BpTriggerResults.BpTrig gerResults.Execute()
Complied ... in Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerResults.BpTri ggerResults
Preparing rule...
Microsoft.SqlBpa.Rules.BpUserObjectsInMasterDataba se.BPUserObjInMaster
Getting all user objects in master database ... BPUserObjInMaster.Execute()
Not Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUserObjectsInMasterD atabase.BPUserObjInMaster
Preparing rule... Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPUserOb jNaming
Partially Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPU serObjNaming
Preparing rule...
Microsoft.SqlBpa.Rules.BpVirtualLogFileCount.BPVir tualLogFiles
Partial Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpVirtualLogFileCount. BPVirtualLogFiles
Preparing rule... Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints
Getting objects information
...Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpWithHints.BpWithHint s
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope
Getting objects information
...Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpXactScope.BpXactScop e
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchemaChec k
Checking for schema 'sys' ... BPSysSchemaCheck.Execute()
Complied ... in BPSysSchemaCheck.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchem aCheck
I have a similar problem. First time (yesterday) BPA worked fine. Today it
cant work.
I just desistaled and instaled again but it doesnt work.
The log
Microsoft.BPA.Server.JobCoordinatorComponent.JobCo ordinatorException:
Execution log not found in the repository
Server stack trace:
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.updateJobStatus(Int32
jobProgress, Status jobStatus, Boolean fExecutionComplete, Boolean
fNoException)
...
Any suggestion?
"jake" <rondican@.hotmail.com> escreveu na mensagem
news:%234np4kR7EHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am trying to run the best practices analyzer and am getting some
time
> out errors. Attached is the log. Any help would be greatly appreciated.
>
>
> Log:
> //--
> Best Practice log file created at 12/22/2004 10:46:18 AM
> Job name: Test
> Log file: c:\program files\microsoft sql server best practices
> analyzer\log\Test_comp-l-db_0001_comp-L-DB%DBServer_SQLBestPA.log
> //--
> Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
> Getting affinity mask setting... BPAffinityMask.Execute()
> Complied ... in BPAffinityMask.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffin ityMask
> Preparing rule...
Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.BPAllo wUpdate
> Getting 'allow update' information... BPAllowUpdate.Execute()
> Complied ... in BPAllowUpdate.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.B PAllowUpdate
> Preparing rule... Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAutoStat s
> Getting AUTO_STAT information for each database... BPAutoStats.Execute()
> Complied ... in BPAutoStats.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAut oStats
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad
> Getting objects information
>
...Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad .BpCreateDatabaseForLoad.Ex
ecute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at
>
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad.Execu
te()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoa d.BpCreateDatabaseForLoad
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCurs orForUpdate.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCu rsorForUpdate
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorU sages.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCursorUsages.BpCurso rUsages
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLevel
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLe vel
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
> Getting machine name and list of databases ... BpFileCompression.Execute()
> Complied ... in BpFileCompression.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
> Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDBBacku ps
> Getting database names ... BPDBBackups.Execute()
> Getting readonly state and backup infor for each database ...
> BPDBBackups.Execute()
> Partially Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDB Backups
> Preparing rule... Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPMsMSDB Backup
> master: Database has been backed up in the specified period.
> msdb: Database has been backed up in the specified period.
> Complied ... in BPMsMSDBBackup.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPM sMSDBBackup
> Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
> Getting current date ... BPNoLogBackup.Execute()
> Getting machine name and server instance ... BPNoLogBackup.Execute()
> Getting info from NT Event Log ... BPNoLogBackup.Execute()
> Complied ... in BPNoLogBackup.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
> Preparing rule...
Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.BPDbSQ LOptions
> Getting databases and SQL option settings... BPDbSQLOptions.Execute()
> Partially Complied ... in BPDbSQLOptions.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.B PDbSQLOptions
> Preparing rule... Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefaultsR ules
> Not Complied ... in BpDefaultsRules.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefa ultsRules
> Preparing rule... Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepreca tedSP.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepre catedSP
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpDatabaseFilePlacement.BPD BFilePlacement
> Getting all DB Names... BPDBFilePlacement.Execute()
> Getting file placement information... BPDBFilePlacement.Execute()
> Partially Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseFilePlacemen t.BPDBFilePlacement
> Preparing rule... Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNul l.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsN ull
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
> Getting machine and instance name... BPNoLogBackup.Execute()
> Getting error log path... BPNoLogBackup.Execute()
> Getting log size ... BPNoLogBackup.Execute()
> Complied ... in BPFailedBackupEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
> Preparing rule...
Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpr essionAlias.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpExpressionAlias.BpEx pressionAlias
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
> Getting current date ... BPFailedBackupEvent.Execute()
> Getting machine name and server instance ... BPFailedBackupEvent.Execute()
> Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
> Complied ... in BPFailedBackupEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
> Preparing rule... Microsoft.SqlBpa.Rules.BPFibers.BPFibers
> Getting lightweight pooling setting... BPFibers.Execute()
> Complied ... in BPFibers.Execute()
> Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BPFibers.BPFibers
> Preparing rule...
>
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimiz
ed
> Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
> Complied ... in BPFTBackgroundServicesOptimized.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOp
timized
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTBlobExtensionType.BPFTB lobExtension
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTBlobExtensionType. BPFTBlobExtension
> Preparing rule... Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPFTCata logs
> Getting all databases... BPFTCatalogs.Execute()
> Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPF TCatalogs
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFullTextCatalogPlacement. BPFullTextCatPlacement
> Getting all databases... BPFullTextCatPlacement.Execute()
> Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogPlace ment.BPFullTextCatPlacemen
t
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnabled.B PFTChangeTracking
> Getting databases... BPFTChangeTracking.Execute()
> Complied ... in BPFTChangeTracking.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnab led.BPFTChangeTracking
> Preparing rule... Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplic ate.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupl icate
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
> Getting machine name ... BPFTMSSearchLocalSystem.Execute()
> Complied ... in BPFTMSSearchLocalSystem.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
> Getting machine name... BPFTPropertyStore.Execute()
> Complied ... in BPFTPropertyStore.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
> Preparing rule...
>
Microsoft.SqlBpa.Rules.BpFullTextIndexedTimestampC olumn.BPFTIndexedTimestamp
Column
> Complied ... in BPFTIndexedTimestampColumn.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFullTextIndexedTimes tampColumn.BPFTIndexedTime
stampColumn
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpIndexDefragmentation.BPIn dexDefrag
> Getting database names ... BPIndexDefrag.Execute()
> Complied ... in BPIndexDefrag.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpIndexDefragmentation .BPIndexDefrag
> Preparing rule... Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpIndexType.BpIndexTyp e
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpInsertColList.BpInsert ColList.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpInsertColList.BpInse rtColList
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpInvalidUserTables.BpInval idUserTables
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpInvalidUserTables.Bp InvalidUserTables
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.BPFixe dLogGrowth
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.B PFixedLogGrowth
> Preparing rule... Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMaxServ erMem
> Getting config values... BPMaxServerMem.Execute()
> Getting all databases & full-text enabled status ...
> BPMaxServerMem.Execute()
> Not Complied ... in BPMaxServerMem.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMa xServerMem
> Preparing rule... Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsi Outer.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAn siOuter
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
> Not Complied ... in NoPk.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuilt ins.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBui ltins
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Exec ute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Execute ()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysT ables.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSy sTables
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrde rByOrdinals.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOr derByOrdinals
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BPDBDis kSpace
> Checking db size... BPDBDiskSpace.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BP DBDiskSpace
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled.BPPr iorityBoost
> Getting 'priority boost' information... BPPriorityBoost.Execute()
> Not Complied ... in BPPriorityBoost.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled .BPPriorityBoost
> Preparing rule... Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQuali fiedNames.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQua lifiedNames
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPRecInt erval
> Getting current recovery interval setting... BPRecInterval.Execute()
> Complied ... in BPRecInterval.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPR ecInterval
> Preparing rule... Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPReuseBk upFile
> Getting readonly state and backup info for each database ...
> BPReuseBackupFile.Execute()
> Complied ... in BPReuseBackupFile.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPRe useBkupFile
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.BPRecM odelUsage
> Getting database names ... BPRecModelUsage.Execute()
> Partially Complied ... in BPRecModelUsage.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.B PRecModelUsage
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
> Getting current date, machine name, and instance name ...
> BPSevereErrorEvent.Execute()
> Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
> Complied ... in BPSevereErrorEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
> Preparing rule... Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Exec ute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Execute ()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSize.BP SetWorkingSetSize
> Getting config values... BPSetWorkingSetSize.Execute()
> Complied ... in BPSetWorkingSetSize.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSi ze.BPSetWorkingSetSize
> Preparing rule... Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Ex ecute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Execu te()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
> Getting current date, machine name, and instance name ...
> BPUnexpectedShutdown.Execute()
> Getting startup and shutdown info from NT Event Log ...
> BPUnexpectedShutdown.Execute()
> Identifying possible undexpected shutdowns ...
> BPUnexpectedShutdown.Execute()
> Retrieveing possible begin time for unexpected shutdown prior to startup
...
> BPUnexpectedShutdown.Execute()
> Complied ... in BPUnexpectedShutdown.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
> Preparing rule... Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfig ure.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConf igure
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOptio n.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpt ion
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpStar.BpStar
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BpStar.BpStar
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpNullServername.BPNullServ er
> Getting @.@.servername... BPNullServer.Execute()
> Complied ... in BPNullServer.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNullServername.BPNul lServer
> Preparing rule... Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BPTempD BSize
> Complied ... in BPTempDBSize.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BP TempDBSize
> Preparing rule... Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTempTables.BpTempTable s.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTempTables.BpTempTab les
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOr derBy.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNo OrderBy
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
> Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerNested.BpTrig gerNested
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTrigg erNoCount.Execute()
> Not Complied ... in
Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTri ggerNoCount
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTriggerResults.BpTrigg erResults.Execute()
> Complied ... in Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerResults.BpTri ggerResults
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpUserObjectsInMasterDataba se.BPUserObjInMaster
> Getting all user objects in master database ...
BPUserObjInMaster.Execute()
> Not Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpUserObjectsInMasterD atabase.BPUserObjInMaster
> Preparing rule...
Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPUserOb jNaming
> Partially Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPU serObjNaming
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpVirtualLogFileCount.BPVir tualLogFiles
> Partial Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpVirtualLogFileCount. BPVirtualLogFiles
> Preparing rule... Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpWithHints.BpWithHint s
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpXactScope.BpXactScop e
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchemaChec k
> Checking for schema 'sys' ... BPSysSchemaCheck.Execute()
> Complied ... in BPSysSchemaCheck.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchem aCheck
>
>
|||Hi, Jake
I have the same problem...
Do you found a solution ?
Thanks
Regards
Thierry
Message posted via http://www.sqlmonster.com
|||Hi Thierry,
Are you seeing any timeouts in the log?. Could you explain the sequence of
steps you did to hit this error?.
It would be great if you could post the full log
Thanks
Sethu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Thierry via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:31f24cc7f1a94cb3a1f486af99bfeb9e@.SQLMonster.c om...
> Hi, Jake
> I have the same problem...
> Do you found a solution ?
> Thanks
> Regards
> Thierry
> --
> Message posted via http://www.sqlmonster.com