Viewing 15 posts - 12,631 through 12,645 (of 49,552 total)
Call Product Support and open a case, you're getting SQL dumping stack dumps, this is potentially a severe problem.
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
June 20, 2013 at 7:56 am
Yes! Get them young, indoctrinate them early. 😀
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
June 20, 2013 at 7:53 am
Please post the full, complete and unedited output of the following.
DBCC CheckDB(<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
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
June 20, 2013 at 7:52 am
Krishna1 (6/20/2013)
Thank with the script given it working fine. I was trying through SSMS and it was creating the issue. Dont know whats going wrong when i try 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
June 20, 2013 at 6:54 am
nivedita talukdar (6/20/2013)
Had checked the rollover option as it is by default but no use...job still fails..
Yes, it will. The rollover's not for restarting the job, it's for running 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
June 20, 2013 at 6:41 am
Could also maybe see error 605
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
June 20, 2013 at 6:31 am
You don't need to create a database before restoring a backup. Just do the restore don't waste time creating a DB just to over write 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
June 20, 2013 at 6:27 am
CREATE DATABASE TestingRecoveryModel
GO
ALTER DATABASE TestingRecoveryModel SET RECOVERY SIMPLE
GO
BACKUP DATABASE TestingRecoveryModel TO DISK = 'C:\Databases\Backups\Testing.bak'
GO
USE TestingRecoveryModel
GO
create table a ( a1 char(1000) default 'a1',
a2 char(1000) default 'a2',
a3 char(1000) default 'a3',
a4 char(1000)...
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
June 20, 2013 at 6:24 am
Krishna1 (6/20/2013)
Sorry what i meant was "How to check active transaction?" (not log :))
DBCC OPENTRAN
Also checked the log_reuse_wait_desc (select name, recovery_model_desc, log_reuse_wait_desc,* from sys.databases where name 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
June 20, 2013 at 5:07 am
Either the backup is damaged or the network returned incorrect data for the backup.
Try getting a fresh backup, copying it local and restoring again
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
June 20, 2013 at 4:58 am
Yes, and it's trivial to test and prove.
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
June 20, 2013 at 4:52 am
Yusuf Ali Bhiwandiwala (6/20/2013)
Thanks Gail for your reply, but what do you think about partitition elimination for performance benefit?
Fine, when it works and when it's better than what the optimiser...
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
June 20, 2013 at 4:43 am
Hang on...
If you need to audit 24/7/365, why are you running the trace every 5 minutes? Set a larger file size, set a rollover (BoL will show you how 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
June 20, 2013 at 4:39 am
What do you mean by 'active transaction log'? There's always a portion of the log that's active.
If you want to check log behaviour:
Create one database switch it to simple 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
June 20, 2013 at 4:29 am
That means you just switched to simple and a checkpoint hasn't occurred. The wait types don't change instantly, run a checkpoint and the Log Backup will disappear.
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
June 20, 2013 at 3:57 am
Viewing 15 posts - 12,631 through 12,645 (of 49,552 total)