Viewing 15 posts - 16,456 through 16,470 (of 19,560 total)
I have seen Veritas report as failed but the job is actually successful. What is the extension of your log backup files (IIRC Veritas likes to use a different...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:29 am
I would have to still go with SSMS - it comes free with SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:16 am
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yup
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:12 am
There is a nice compilation of samples here:
http://www.connectionstrings.com/sql-server-2005
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:10 am
Backup summary.
Avg Disk Reads / Writes
SCOM could get you some of the info you need. Other options are to use PowerShell, SMO, tsql scripts to build a custom in-house...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:06 am
Steve and GTR have provided good information.
The log backups are due to either a job or a manual intervention.
You also might want to verify if Log-Shipping is present.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:02 am
I recommend you follow the steps outlined in the Log Growing pains article here:
http://www.sqlservercentral.com/articles/Log+growth/69476/
This can help you identify the source of the growth and then you can optimize and correct...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:00 am
What versions of SQL Server? What kind of environment (clustered, replication)?
A little more information might be helpful.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 10:51 am
Nice Question Ron.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 10:42 am
Paul White (3/15/2010)
Jeff Moden (3/15/2010)
Heh... you must really be bored, Paul. 🙂
Actually, I had to think quite hard to get that cursor right. I am not proud of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 10:25 am
GSquared (3/15/2010)
Roy Ernest (3/15/2010)
Happy B'Day Grant...And Gus Belated B'day wishes for you.
Thanks. 🙂
Hope you had a good birthday as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 10:23 am
Lynn Pettis (3/15/2010)
GilaMonster (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 10:22 am
Steve Jones - Editor (3/15/2010)
Happy Birthday, Grant, from SQLServerCentral!
With that you get a PorkChop with B-day candles in it. :w00t:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 9:34 am
Alvin Ramard (3/15/2010)
In case you didn't know, it's Grant's birthday today. 😀Happy Birthday again Grant.
Happy Birthday Grant
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 9:32 am
Ray K (3/15/2010)
Paul White (3/15/2010)
Ray K (3/15/2010)
Asterix and Obelix! Cool!Good to see I'm not alone 😀
I practically grew up with Asterix books! I miss reading those things!
You can...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 9:30 am
Viewing 15 posts - 16,456 through 16,470 (of 19,560 total)