Viewing 15 posts - 41,026 through 41,040 (of 49,552 total)
Please post in an appropriate forum in the future. The article discussion forums are for article discussions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2009 at 12:17 am
louisevb (2/16/2009)
Do you have any advise from your side?
Stop worrying about the certs and concentrate on learning the basics well. Certs are fine later, when you have some experience...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2009 at 12:13 am
Jeff Moden (2/16/2009)
How much of this applies to the system's databases (not including TempDB, of course)?
MSDB can be repaired, I believe (haven't tried it). Master I would recommend...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2009 at 12:08 am
Ninja's_RGR'us (2/16/2009)
I just saw Gail's post, I guess that's why I can't get this to work >>>
You need to backup the log before the restore, not after. After a restore...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2009 at 12:02 am
scottdever (2/16/2009)
The error logs just say that sql cannot access the ldf files.
It should have given a reason (Operating system error.....)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 11:47 pm
Magy (2/16/2009)
Ok, all I see is FULL in the backup_type. How do I turn on transactional logs?
For transaction log backups, see the entry in Books Online "Backup log"
it's not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:40 am
Check the SQL error log. There should be some info in there. Please post any relevant log entries
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:33 am
louisevb (2/16/2009)
I have decided to change my career from accounting to Database Developer
Why? What is it about databases that interests you?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:32 am
Check the sql error log. If the DBs are getting marked suspect, there will be entries in there saying why.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:28 am
digitalox (2/14/2009)
GilaMonster (2/14/2009)
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
Good point, not sure why but I've always been...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:25 am
eashoori (2/16/2009)
I thought Transact log backup actually help the performance during busy hours, is it not true?
Backups are for recoverability, not performance
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:21 am
kladibeeto (2/16/2009)
Conclusion:If You DON'T perform transactional log backup's
You need to do this:
Execute:
BACKUP LOG DatabaseName with truncate_only
DBCC SHRINKFILE (FILENAME, 1000)
Set recovery model to simple.
If you aren't doing log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:09 am
DBADave (2/14/2009)
CXPackets occur when a query has its operations run in parallel, but not all operations complete at the same time.
Not all threads processing a single query operator...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:06 am
Jack Corbett (2/16/2009)
I just hope I never have to reference it to fix any of my DB's. 😀
I hope so too. This is an article that I would like...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 8:00 am
kladibeeto (2/16/2009)
Please explain me which log chain will he break if he don't work transactional log backups?
Please read the article that ALZDBA linked to above. It's explained in there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2009 at 7:58 am
Viewing 15 posts - 41,026 through 41,040 (of 49,552 total)