Viewing 15 posts - 39,001 through 39,015 (of 49,552 total)
Restore a full backup and any tran logs you need. You're not going to get the DB back into standby in a state that will allow logs to be applied...
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
May 20, 2009 at 8:28 am
too_sweeeeeeeet (5/12/2009)
I have a function that contains the following query which is always timimig out.select distinct @Result = sum( column1 )
from table (nolock)
where ((column2 = @param1) or (@param1 = 0))
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
May 20, 2009 at 7:10 am
To bring a database from STANDBY to ONLINE, run the following
RESTORE DATABASE <Database Name> WITH RECOVERY
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
May 20, 2009 at 7:02 am
ip2host (5/20/2009)
I didnt correctly express myself.I truncated trans logs after full backup each base and trans log.
Are you running BACKUP LOG ... WITH TRUNCATE_ONLY at all? If so, please read...
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
May 20, 2009 at 6:56 am
guptaajay1985 (5/20/2009)
Will I ever get that deleted data..
No. The data that was on the pages that checkDB deallocated is gone, permanently.
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
May 20, 2009 at 3:32 am
guptaajay1985 (5/20/2009)
When I have run DBCC checkdb (postnet,repair_allow_data_loss) it gives in red color...
Good. It looks like everything's repaired. Run checkDB again (without any repair option, just as I gave 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
May 20, 2009 at 1:23 am
ip2host (5/20/2009)
Learned how to truncate trans log instead of deleting them.
That's something that you need to unlearn, I'm afraid. Transaction logs should not be truncated, they should be backed...
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
May 20, 2009 at 1:01 am
Try running restore with the CONTINUE_AFTER_ERROR option. If that doesn't work then the backup is not restorable.
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
May 20, 2009 at 12:57 am
SQL_Monster (5/20/2009)
Can any suggest and let me know that if CPU is in 100% utilization then the new processes will not be accepted.
No
CPU utilization 100% = Utilizing total memory of...
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
May 20, 2009 at 12:55 am
Glenn Dorling (5/19/2009)
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
May 20, 2009 at 12:52 am
Ok, you've got 4 pages that have been trashed somehow. Since you do not have a clean backup, you're going to have to run repair. Note that REPAIR_ALLOW_DATA_LOSS, as it'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
May 20, 2009 at 12:45 am
Eric Butler (5/19/2009)
Example, under CREATE DATABASE ...
Therefore, when 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
May 20, 2009 at 12:36 am
Not as far as I'm aware.
In fact, it's a reasonably well known 'trick' to add "--password" to the end of a query to stop profiler from showing the code 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
May 19, 2009 at 4:58 pm
Eric Butler (5/19/2009)
My ultimate goal is to:
1 - detach a log-shipped database (databaseA) which...
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
May 19, 2009 at 4:48 pm
Tim Walker (5/19/2009)
The DATA_PURITY option just performs more limited checks.
DATA_PURITY
Causes DBCC CHECKDB to check the database for column values that are not valid or out-of-range. For example, DBCC CHECKDB detects...
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
May 19, 2009 at 4:46 pm
Viewing 15 posts - 39,001 through 39,015 (of 49,552 total)