Viewing 15 posts - 18,286 through 18,300 (of 49,552 total)
If you need to sync restores of multiple databases, then you need log backups, marked transactions and a RESTORE ... WITH STOPBEFOREMARK
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 4, 2012 at 9:54 am
ben.brugman (6/4/2012)
Suppose the backup lasted for 2 hours. Is the backup then the situation from the beginning, the end, the middle, totaly unknown?
Near the end. To be specific, it'll be...
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 4, 2012 at 9:27 am
logicinside22 (6/4/2012)
but if you can advise other steps would be fine.
Did you read the chapter I recommended?
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 4, 2012 at 9:06 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1310518-391-1.aspx
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 4, 2012 at 8:54 am
First thing, resist the urge (and ignore any advice) that tells you to set maxdop to 1.
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 4, 2012 at 8:53 am
Sean Lange (6/4/2012)
You have an OPEN statement off all by itself.
Open is the alias for the subquery. It's valid, though probably should be in [] as a reserved...
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 4, 2012 at 8:52 am
AndrewSQLDBA (6/4/2012)
Thanks Gail and SteveSo I can shrink that logs without messing up the LSNs?
Of course. Shrinking will never break anything or interfere with the log in any way...
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 4, 2012 at 8:51 am
So the bad block came across with the snapshot backup? Ow... Try copying the files with SQL stopped, see if that will get rid of 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 4, 2012 at 8:11 am
The databases are in full recovery so you absolutely have to take log backups on the principal or the log will grow til it fills the drive.
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 4, 2012 at 7:21 am
If you stop SQL Server, can you copy the files? Alternately, did that snapshot backup work, can you restore that elsewhere and check that it's OK?
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 4, 2012 at 7:19 am
One thing that was part of my introductory course for my M.Sc was 'why are you doing this?' and it made it very clear that if you're just doing an...
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 4, 2012 at 5:52 am
SKYBVI (6/4/2012)
If you memorise answers, you will be lost as soon as the interviewer digs into details. If you've played around and have practical experience you won't be.
Thats true I...
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 4, 2012 at 5:49 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 4, 2012 at 5:08 am
Decode is an Oracle function, not SQL Server. What are you trying to do?
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 4, 2012 at 5:06 am
Please post new questions in a new thread. Thank 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 4, 2012 at 5:04 am
Viewing 15 posts - 18,286 through 18,300 (of 49,552 total)