Viewing 15 posts - 24,931 through 24,945 (of 49,552 total)
You said in your initial post that the following didn't work:
alter database test
set emergency
go
alter database test
set single_user
go
dbcc checkdb (test, repair_allow_data_loss)
alter database test
set multi_user
go
I asked what errors they gave and what...
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
July 13, 2011 at 8:56 am
Eric M Russell (7/13/2011)
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
July 13, 2011 at 8:41 am
Nope, that's not restorable at all.
You didn't answer my question about the checkDB 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
July 13, 2011 at 8:39 am
Link doesn't explain anything.
If all you're doing is putting a mark in the log at a specific time, how is that any different to restoring with stopat that specific time?...
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
July 13, 2011 at 3:25 am
Why is ProdCC missing? It's listed in the AccountProducts table, the accountID joins to a valid row in Accounts
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
July 13, 2011 at 2:03 am
Check the default trace, if it's still in there you can get the login name. If it's not, then there's no way to tell.
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
July 13, 2011 at 1:50 am
Why is stopat = time not reliable across multiple servers if you want to stop at a point in time?
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
July 13, 2011 at 1:41 am
GilaMonster (7/13/2011)
A varchar takes 2 bytes + the number of bytes stored in 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
July 13, 2011 at 1:40 am
shilpa.shankar87 (7/13/2011)
i have enabled awe and now memory consumed by sqlserver.exe is bit reduced, i dont know whether doing this is good idea or not
On 64-bit SQL, the AWE setting...
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
July 13, 2011 at 1:40 am
Prakash.Bhojegowda (7/12/2011)
Use below statement... it will work!ALTER INDEX [IndexName] ON [Schema].[Tablename] REBUILD WITH (ONLINE = ON);
It will work for Indexes with pages less than 10.
It works for...
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
July 13, 2011 at 1:37 am
Please post your execution plans. It's impossible to get meaningful performance results on 10 rows
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
July 13, 2011 at 1:36 am
Memory-allocation is not as simple as it sounds. Storage per row is easier to explain.
A varchar takes 2 bytes + the number of bytes stored in 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
July 13, 2011 at 1:18 am
Trying to understand... Rows from Account where there's no matching row in Product_Account?
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
July 13, 2011 at 1:17 am
Grubb (7/12/2011)Gail, what is your Avatar a picture of?
Marcus Cole. Character on Babylon 5. Same place my sig quote is from.
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
July 13, 2011 at 1:12 am
What errors are you getting? What's the current status of the DB?
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
July 12, 2011 at 2:24 pm
Viewing 15 posts - 24,931 through 24,945 (of 49,552 total)