Viewing 15 posts - 17,056 through 17,070 (of 49,552 total)
Nothing wrong in there, but since the last message is SQL starting to open the DBs, any useful messages will be after that point.
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
August 21, 2012 at 2:47 am
AdventureWorks should not be used as an example of good database architecture. It's far too complex for what it is. It's a showcase of every feature that SQL has, 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
August 21, 2012 at 2:27 am
SQL encounters corruption in the data file or log file when rolling back a transaction.
SQL encounters corruption in the data file or log file when running crash recovery.
Typically, 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
August 21, 2012 at 2:21 am
<soapbox>
Cursors are tools. Use them where they work, don't use them where they don't. Statements like 'you should never use a <whatever>' are just shortsighted
If we count while loops as...
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
August 21, 2012 at 2:18 am
I'm not going to get into a huge debate because as the previous thread proved, you're willing to twist my words and ignore portions of what I say just 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
August 21, 2012 at 2:15 am
sql2k8 (8/20/2012)
commun z:\DATA\Commun.mdf 0ONLINE ...
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
August 21, 2012 at 1:57 am
Actually it probably will be.
That query returns the total size of the DB files. A backup does not back up the entire file, just the used portion of 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
August 20, 2012 at 4:23 pm
That should work (though you need to patch the destination, it's vulnerable to slammer at the very least)
There are only 2 cases I know of where a service pack bumped...
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
August 20, 2012 at 3:42 pm
Error log please.
What is the exact state of that database?
Check sys.database_files, what log files does it have, are they all where they should be?
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
August 20, 2012 at 3:40 pm
Errors please.
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
August 20, 2012 at 1:01 pm
Truncate table is a logged operation (there are no unlogged data modifications in SQL). It can be rolled back, it can be mirrored. It's technically even a fully-logged operation.
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
August 20, 2012 at 12:06 pm
Yup, the DB will be recreated exactly as it was at the time of backup. Caught me too, had a 50GB backup file that needed 120GB to restore (empty 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
August 20, 2012 at 11:01 am
Are you sure CheckDB is running, not just a message saying when it last ran?
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
August 20, 2012 at 10:39 am
Ok, so what's the problem? Was it just in running CheckDB?
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
August 20, 2012 at 9:54 am
That's not interesting (and shouldn't be in the SQL error log anyway)
Is the log file present where it should be? Is the drive online, etc? What's the state of 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
August 20, 2012 at 9:47 am
Viewing 15 posts - 17,056 through 17,070 (of 49,552 total)