Viewing 15 posts - 36,961 through 36,975 (of 49,552 total)
GSquared (8/19/2009)
I just read that article, and I don't see where data loss is mentioned. What am I missing?
Likewise.
It mentions that Shrink truncates the log which might be true...
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
August 19, 2009 at 7:21 am
ekonagu (8/19/2009)
size of db wil be 5 gb and down time can be 30 min
Then you need to design a backup strategy so that, no matter what, you can...
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
August 19, 2009 at 2:22 am
Why don 't you just use sp_attach_rebuild_log? No need for all the other work.
p.s. Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post...
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
August 19, 2009 at 2:20 am
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!
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
August 19, 2009 at 1:54 am
There's no single perfect backup strategy. It depends on the size of the DB, the amount of data that's allowed to be lost in the case of a disaster, 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
August 19, 2009 at 1:49 am
If the DB is in simple recovery then the transaction log will be getting automatically truncated every minute or so, and there will be no way to get info older...
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
August 19, 2009 at 1:48 am
I've had probation periods at two of the companies that I've worked for. They have to be very carefully set up in the contracts (labour laws are quite strict here...
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
August 19, 2009 at 1:35 am
It means that either the log or the database file has been damaged in some way. If you can attach with just the mdf, great, but please run a CheckDB...
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
August 19, 2009 at 12:11 am
Jeff Moden (8/18/2009)
Why not simply cover the mistake by taking what would have gone on an entirely new page and simply replace the original page?
Couple possible reasons.
- It would have...
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
August 19, 2009 at 12:08 am
shannonjk (8/18/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
August 18, 2009 at 3:07 pm
I'm going to consult an expert on this one. Please be patient...
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
August 18, 2009 at 1:45 pm
Does restarting the instance fix that?
If not, can you please run the following and post any output that it returns
DBCC CHECKDB ('Model') WITH NO_INFOMSGS, ALL_ERRORMSGS
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
August 18, 2009 at 12:55 pm
First thing we need to see is the SQL error logs. There should be a message in there indicating why MSDB is suspect. Hopefully, it'll be something easy to resolve.
If...
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
August 18, 2009 at 12:46 pm
It's good practice if that is the largest the transaction log will ever need to be. 1GB is pretty small for a transaction log, unless it's a relatively small and/or...
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
August 18, 2009 at 12:43 pm
russ (8/18/2009)
Simple and Full recovery models?
Simple : BACKUP DATABASE TO DISK = ''
Full :...
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
August 18, 2009 at 12:19 pm
Viewing 15 posts - 36,961 through 36,975 (of 49,552 total)