Viewing 15 posts - 36,481 through 36,495 (of 49,552 total)
Mark Marinovic (10/1/2009)
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
October 1, 2009 at 12:15 pm
Melton (10/1/2009)
Duration column within profiler indicates how long the process took in milliseconds.
Depends.
SQL 2005 and above actually measure duration in microseconds, not milliseconds. There's an option in the profiler GUI...
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
October 1, 2009 at 12:11 pm
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
October 1, 2009 at 12:09 pm
william.crawley (10/1/2009)
This differential backup cannot be restored because the database has not been restored to the correct earlier state.Msg 3013, Level 16, State 1, Line xx
Sounds like you're either...
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
October 1, 2009 at 12:09 pm
repent_kog_is_near (10/1/2009)
In a Full Recovery model, after every transaction log is backed up, is it worth shrinking the Log File?
Only if you want to slow the DB down as it...
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
October 1, 2009 at 9:54 am
Samji_S (10/1/2009)
Yes, we do take log backups every 10 minutes and for my bad we recycle t-logs every 3 days :crying :
*sigh* You waited 2 weeks to fix a critical...
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
October 1, 2009 at 3:17 am
litu deb (10/1/2009)
As server is running out of space i have to shrink either log files/database file.I can't take log back up because of space issue.
Have you requested more space...
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
October 1, 2009 at 3:11 am
Why, on a server with 12 GB of memory, do you have the max for SQL Server set at 6? Are there other things running on this server?
32 bit or...
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
October 1, 2009 at 1:33 am
p.s. oh, the reason for the 67GB log file and small mdf. Full recovery model, no log backups. In that state, once the firstr full backup has been taken, 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
October 1, 2009 at 1:23 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in 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
October 1, 2009 at 1:20 am
Try dropping the database completely and then restoring a complete new copy. The errors may have to do with trying to replace a file that isn't there.
Restore will put a...
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
October 1, 2009 at 1:19 am
Samji-389836 (9/30/2009)
We are getting this consistency errors since two weeks, that means I should be restoring affected...
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
October 1, 2009 at 1:04 am
As far as I know, that's not a repairable error.
Do you have a clean backup (one without these errors)? If so, restore it.
If not, try taking the DB into...
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
September 30, 2009 at 9:58 am
river-653653 (9/30/2009)
What about using BDCC shrink file instead of using the GUI (EM) to shrink the log file?
All the GUI does is run DBCC ShrinkDatabase or DBCC ShrinkFile.
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
September 30, 2009 at 9:44 am
ErickTreeTops (9/30/2009)
I have tried to disable the FK constraints temporarily so that i can remove the records but the usual syntax appears not to work.
You have to drop the constraint...
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
September 30, 2009 at 1:46 am
Viewing 15 posts - 36,481 through 36,495 (of 49,552 total)