Viewing 15 posts - 3,886 through 3,900 (of 49,552 total)
You might be able to take a tail-log backup by switching to Emergency mode, but no full or diff, and you probably wouldn't want to backup a corrupt 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
January 7, 2016 at 2:13 am
n.heyen (1/6/2016)
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
January 6, 2016 at 4:04 pm
If you mean ALTER DATABASE to drop an LDF (can't drop the last one), then that should be in the default trace. If you mean an OS file delete, 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
January 6, 2016 at 4:02 pm
No, that's not what I said.
The error message says that you are trying to either overwrite an *existing* database that is currently attached to the instance, or you're trying 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
January 6, 2016 at 2:27 pm
From that message, the Prod1_Content database exists on the server and you're trying to overwrite it. Is that correct?
If that's not what you intend, double-check the database and file names.
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
January 6, 2016 at 12:56 pm
erics44 (1/6/2016)
Lynn Pettis (1/6/2016)
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
January 6, 2016 at 12:46 pm
You can, but proportional fill will mean that the new file will get the bulk of new data. Trying to balance that out won't be trivial (rebuild all clustered indexes)
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
January 6, 2016 at 7:17 am
Hugo Kornelis (1/6/2016)
GilaMonster (1/6/2016)
On the same disk, none at all.
... in most scenarios.
If you have a database that has a very high amount of table allocations and deallocations, you can...
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
January 6, 2016 at 6:55 am
That would be my guess as well. Unlike SNAPSHOT isolation level, the READ_COMMITTED_SNAPSHOT setting changes how READ COMMITTED works, changing it to use row versions not locks. If it's turned...
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
January 6, 2016 at 2:51 am
Sergiy (1/5/2016)
try to explain why CTE construction must be prefixed with ";" - there is no such requirement for any other language construction.
THROW - Previous statement must be ; terminated...
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
January 6, 2016 at 2:16 am
On the same disk, none at all. On different disks, maybe. Are you seeing IO contention? If so, is the 'different disk' really different hardware? If yes to both, 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
January 6, 2016 at 2:09 am
And, for a sanity check, what does the following return?
SELECT DB_Name(27)
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
January 5, 2016 at 11:52 am
Odd. What was the exact statement you ran for checkDB and what was the complete output?
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
January 5, 2016 at 10:47 am
That wasn't what I asked.
Are you still getting the error after CheckDB 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
January 5, 2016 at 10:12 am
I'm learning it at the moment. It's best for data analysis, data visualisation. I'd say anyone could find a use for it, even if 'just' an alternative to excel graphs.
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
January 5, 2016 at 7:07 am
Viewing 15 posts - 3,886 through 3,900 (of 49,552 total)