Viewing 15 posts - 15,751 through 15,765 (of 49,552 total)
Thought it was valid on backup database. Ok, so you'll need to take the last of the log backups with norecovery then
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
November 8, 2012 at 3:01 pm
Evil Kraig F (11/8/2012)
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
November 8, 2012 at 2:56 pm
Nope.
The transaction log is not an audit log, it is not important for database recovery or transaction rollbacks what login did the operation, that information is not included...
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
November 8, 2012 at 2:53 pm
Don't do it that way. When you want to take the last backup, run backup database with norecovery (or backup log with norecovery), that'll switch DB into restoring, allow no...
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
November 8, 2012 at 1:40 pm
That's a .Net error message, it's your client app that's run out of memory, not the server, not SQL.
Most likely the plan is complex and the client is low on...
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
November 8, 2012 at 11:03 am
Restore from backup.
IO problems, like most causes of corruption, or someone tried something stupid like replacing the data or log files with older ones, or maybe a HA/DR 'solution' 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
November 8, 2012 at 9:18 am
sys.dm_db_session_space_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
November 8, 2012 at 9:13 am
If you're not taking log backups for point-in-time restore capability, why is the DB in full recovery model in the first place?
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
November 8, 2012 at 9:11 am
You are not giving enough information to help solve the problem.
I suggest you get a copy of the book 'troubleshooting SQL Server' and work through chapter 1.
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
November 8, 2012 at 9:10 am
Go have a look on my blog for a post titled something like 'statistics and the ascending datetime column' (google's the easiest way.
Sorry, don't have link handy.
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
November 8, 2012 at 9:01 am
Ignore avg disk queue length 'thresholds' completely. It's extremely hard to interpret with all that's between a server and its disks these days. Trend it, look for changes from normal...
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
November 8, 2012 at 8:59 am
No where near enough information. Identify the queries with excessive wait times and investigate 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
November 8, 2012 at 1:51 am
It's your server, you're the one who can tell if that's normal for your server.
If you feel that's excessive for your server, or you want to reduce it, investigate what's...
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
November 8, 2012 at 1:48 am
sqladmin 45377 (11/7/2012)
So I shouldn't see any more of these very large translog files unless/until I run another reindex job?
Reindexing should be one of your regular maintenance tasks
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
November 8, 2012 at 12:59 am
AWE no. Locked pages, requires a service restart. If the /PAE switch is not in boot.ini already, that requires a reboot.
32-bit only, on 64 neither PAE nor AWE is relevant.
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
November 8, 2012 at 12:53 am
Viewing 15 posts - 15,751 through 15,765 (of 49,552 total)