Hi Gail,

Thanks for the reply!

Is there a list of operators that course blocking for the whole query (Ive never heard of it.. which isn't difficult to be honest,...

Hi Gail,

i just found a Jon K script that im guessing.. no guessing it says it right there.. ill stop being blind!.. it throw out a very nice table...

Hi,

I was just hoping to be able to get it from the event log since i already have the xml output and text.. We run SQL Monitor that uses...

thanks Perry ill take a look.

Log from running the Ola H checkdb

DateTime: 2012-09-04 13:36:46

Database: [master]

Status: ONLINE

Standby: No

Updateability: READ_WRITE

User access: MULTI_USER

Is accessible: Yes

Recovery model: SIMPLE

DateTime: 2012-09-04 13:36:46

Command: DBCC CHECKDB ([master]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY

Outcome: Succeeded

Duration:...

Hi Gail,

No users are complaining and i can get multiple connections to Master, so it seems ok. Just weird and wasn't sure if it would lead to problems.

Is...

Just some updates..

sp_help 'master' returns:

namedb_sizeownerdbidcreatedstatuscompatibility_level

master 6.75 MBsa1Apr 8 2003Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=661, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics100

SELECT name, user_access_desc

FROM sys.databases

where name =...

Thanks sir

clears up a lot of questions i had.. and not really related to the starting question so thanks for sticking with me!

hey,

the delete old log backups on primary and secondary is set to 72 hours.. Is that what you mean? I don't remember any other thresholds..

thanks 🙂

EDIT...

think before...

Hi Perry thanks!

Can i just confirm im understanding it right.

CASE 1 - logs retained on Primary and secondary for 24 hours - 1 hour LINK down

10:00 - Log backup...

Hi,

Yes had a brain melt..

realized that i still had my ola scripts still doing backup logs... Ive removed and started again and seems to be working now.

It did...

Hi guys thanks for the replies...

I ran the scripts.

Primary had details.. But the Secondary was empty... Ive ended up deleting it (thank you for the link) and starting...

sigh so simple...

My logic is fail..

Thank you sir! (again!)

Hi and thank you! you always answer my questions its really appreciated!

I was googling yesterday and it came up on a few post over at stackoverflow (cant find them...

Just watching the Tech Ed vids about Lightswitch (http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV347). It looks like the new version will have the ability to create HTML pages as well as silverlight....