Viewing 15 posts - 21,691 through 21,705 (of 49,552 total)
SQL Kiwi (12/16/2011)
Ninja's_RGR'us (12/16/2011)
Connect items are often closed as Won't Fix before an explanation or more details are provided.
Yes, which quite frankly is a problem in and of itself....
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
December 16, 2011 at 10:46 am
Long weekend here, will take a look on Mon.
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
December 16, 2011 at 10:43 am
Yes, that's what replace means. Replace the DB that's there with the one in the backup and overwrite any files with the same name.
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
December 16, 2011 at 6:12 am
Distribution List.
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
December 16, 2011 at 6:08 am
Ninja's_RGR'us (12/16/2011)
Ninja's_RGR'us (8/19/2011)
Issue posted on connect
As of today, closed as won't fix!!!
You know, it's not like it causes corruption and kills your prod db or anything that serious :sick:
Time to...
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
December 16, 2011 at 5:55 am
Marco V (12/16/2011)
GilaMonster (12/16/2011)
What kind of account is SQL Server running under?and make sure that account has rights to the folder you backup youre db to
And same with the account...
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
December 16, 2011 at 5:27 am
Backups don't take locks of any form, hence they can never be blocked by activity in the database.
It's not a good idea to rebuild indexes and back up at the...
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
December 16, 2011 at 4:46 am
haovard (12/16/2011)
what about shrinking just the log file when the database is set to simple recovery model? Any potential 'fuckups'?
Depends on the circumstances and reasons behind the need to shrink.
If...
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
December 16, 2011 at 4:39 am
muthukkumaran Kaliyamoorthy (12/16/2011)
If your log file grow in simple recovery model, Its because of1. poor application design
2. Poor maintenance design etc
Errr, no way!
Simple recovery does not in any...
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
December 16, 2011 at 4:31 am
Tava (12/15/2011)
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
December 16, 2011 at 4:29 am
Fraggle-805517 (12/15/2011)
An update on this. The MAXDOP statement worked the best. It took the entire process down from 8-15hours to under 5 minutes.
Not fixed. What you've...
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
December 16, 2011 at 4:22 am
Please post the actual code, not something that kinda looks like it. Details you've removed for simplification may well be the cause.
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
December 15, 2011 at 8:45 am
Fraggle-805517 (12/15/2011)
Jeff/Gila, can either of you explain the Holloween Effect (and why they named it that)?
In short, it's an effect in relational databases where an update can affect a row...
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
December 15, 2011 at 7:49 am
When you ran the insert, were you using the correct database? Default for sa is usually master, not a user database.
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
December 15, 2011 at 7:18 am
Jeff Moden (12/15/2011)
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
December 15, 2011 at 5:43 am
Viewing 15 posts - 21,691 through 21,705 (of 49,552 total)