Viewing 15 posts - 29,746 through 29,760 (of 49,552 total)
Shrinking won't affect your backup speed or time at all.
How much free space is in those databases? (sp_spaceused)
How fast are they growing?
Bear in mind that, unless you've just done some...
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 25, 2010 at 8:32 am
400GB is not a huge database. Moderately big at best.
Why do you want to shrink in the first place? It's not recommended, certainly not for regular usage.
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 25, 2010 at 8:18 am
Consider sticking a DDL trigger on the DB to catch all schema changes in future. It's not intrusive.
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 25, 2010 at 8:06 am
Steve Jones - SSC Editor (10/25/2010)
The only other way that might work is with a log reader tool, but you would have to purchase them.
Plus it's unlikely that the 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 25, 2010 at 8:04 am
You're correct. Licensing is per socket or per cal, not per database.
Maybe he meant something else would cost, development changes or the 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
October 25, 2010 at 7:26 am
Semi-duplicate thread.
No more replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1002245-146-1.aspx
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 25, 2010 at 5:50 am
Execution plan costs are estimates. There are several things that can make them completely incorrect.
Bottom line, which is faster? (use Stats time) Which uses lass resources? (stats IO or profiler)
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 25, 2010 at 5:48 am
If this is for display purposes, fine. If this is for storage please reconsider, it will just make things harder to work with.
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 25, 2010 at 5:36 am
You can restart the instance. If the rollback is hung that usually helps. Probably best to do out of business hours in case it takes time to come back.
Have 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
October 25, 2010 at 5:24 am
Wait or restart. There are no other options.
If you restart, the rollback will continue during crash recovery. During this time the database will not be available (unless you have enterprise...
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 25, 2010 at 4:39 am
*nm*
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 25, 2010 at 2:53 am
Wait or restart the SQL instance. If you restart, the rollback will continue after the restart, no way to tell how long it'll take.
Is the rollback perhaps blocked by something?...
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 25, 2010 at 2:53 am
tnk (10/25/2010)
GilaMonster, you are so right. Unfortunately the vendor of the ERP system won't support any kind of replication because they've, "never tested it".
Twits.
Neither transactional nor snapshot replication makes...
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 25, 2010 at 2:51 am
It's a total waste to try and shrink to reclaim around 10MB of space. The DB is tiny already. Leave it alone.
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 25, 2010 at 2:50 am
You're missing a log backup, maybe more than one.
To restore, you need to restore the full backup, then all the log backups taken since that full, in sequence.
p.s. You should...
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 25, 2010 at 2:48 am
Viewing 15 posts - 29,746 through 29,760 (of 49,552 total)