Viewing 15 posts - 25,276 through 25,290 (of 49,552 total)
opc.three (6/29/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
June 30, 2011 at 6:21 am
Please go and do some reading on log shipping, log backups and restore sequences.
Reinitialise as in recreate the log shipping secondary the same way you did when you first set...
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 30, 2011 at 6:17 am
No. It's not going to help at all if determining whether fill factor needs dropping as it makes no distinction between pages allocated in the middle of the index (resulting...
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 29, 2011 at 1:20 pm
tt-615680 (6/29/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
June 29, 2011 at 1:10 pm
With Enterprise edition you can do piecemeal restore, meaning you can restore only some of the non-primary file groups. The primary file group has to always be restored and 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 29, 2011 at 1:06 pm
Next time it happens, check the actual database status. Status_desc in Sys.databases and check the error log.
There's not enough information here to give you a reason.
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 29, 2011 at 1:04 pm
Why's it strange? 2008 R2 is the latest release version of SQL.
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 29, 2011 at 1:02 pm
That's not a native backup. What tool are you using to back up the DB? Have you checked with that company's support to see if this is a known issue?
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 29, 2011 at 12:57 pm
tt-615680 (6/29/2011)
I first Backed up the Transaction Log files usingBACKUP LOG DatabaseName WITH TRUNCATE_ONLY
That did not back up the transaction log. That just discarded log records without backing them...
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 29, 2011 at 5:34 am
Then you lose any ability to do point in time recovery, if there's any disaster you will be able to restore to the last full/diff backup and no further.
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 29, 2011 at 5:33 am
Please note: 4 year old thread.
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 29, 2011 at 2:34 am
pavargasq (6/28/2011)
its a company procedure weve got to run daily at night for freeing up system resources
To be blunt, that's stupid.
Look for the cause, don;t fix symptoms.
p.s. if 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
June 29, 2011 at 2:33 am
durai nagarajan (6/28/2011)
i said i don't find any much use in giving the file name's manually. it has to be automatically taken with some increment type for the successive...
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 29, 2011 at 2:27 am
REinitialise log shipping.
Full or diff backups of a log shipped primary, yes. Log log backups, no.
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 29, 2011 at 2:25 am
Stefan Krzywicki (6/28/2011)
Yeah! That article coming out next Thursday has way too many commas!(With apologies to whomever's article is coming out next Thursday)
Not mine for sure. Mine have far too...
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 28, 2011 at 4:30 pm
Viewing 15 posts - 25,276 through 25,290 (of 49,552 total)