Viewing 15 posts - 32,836 through 32,850 (of 49,552 total)
muhammad.raza (5/17/2010)
PLEASE DO What ever you Could do to Help me in this particular Regrd.
Well you're not paying me, so I'm not going to spend hours or days on this,...
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 17, 2010 at 5:56 am
Dave Ballantyne (5/17/2010)
GilaMonster (5/17/2010)
I'm all for optimism, but it might be just a little bit misplaced here. http://www.sqlservercentral.com/Forums/FindPost922808.aspxMaybe a binary file editor 🙂
Oh a hex editor will work. I 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
May 17, 2010 at 5:54 am
I'm all for optimism, but it might be just a little bit misplaced here. http://www.sqlservercentral.com/Forums/FindPost922808.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
May 17, 2010 at 5:48 am
Please do. I'd be very interested in the reason for this odd scenario.
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 17, 2010 at 5:39 am
You're welcome to feel that way.
Do note that I'm not talking in ignorance here. I know a reasonable amount about corrupt databases and recovering them. I could point 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 17, 2010 at 5:38 am
I'm going to assume you didn't read the article I listed. Please take a minute and do so. Thanks
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 17, 2010 at 4:46 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
May 17, 2010 at 4:34 am
If the rebuild log failed, it's game over. That's the absolute last resort and there's nothing else that can be done.
Try the data recovery tool (yes, you'll have to buy...
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 17, 2010 at 4:31 am
Are there any errors from around that time in the SQL Server error log? CheckDB execution is logged.
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 17, 2010 at 3:50 am
muhammad.raza (5/17/2010)
Upon Attaching The Database it Gives Me Error : "THE FILE You Have Specified Is not Valid SQL Server Datbase File"
You sure it's a mdf file? If you're getting...
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 17, 2010 at 3:49 am
Nothing. It's just the naming standard that MS used in the adventureworks database.
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 17, 2010 at 3:48 am
ianT (5/17/2010)
Why not use SSMS to detach then re-attach (remember to delete the log on the attach dialog) ? Or attach the .mdb to a new SQL instance?
Because that won't...
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 17, 2010 at 2:16 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/Topic922719-9-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
May 17, 2010 at 1:07 am
The recommended approach would be to restore the user databases from backup.
Since you don't have backups, check this blog post for how to force SQL to rebuild the log...
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 17, 2010 at 1:07 am
This is a SQL 2005 server?
What's the type of syskeys?
SELECT type_desc from sys.objects where name = 'syskeys'
Some other important questions.
Has checkDB been running successfully up until now?
Is this...
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 17, 2010 at 1:03 am
Viewing 15 posts - 32,836 through 32,850 (of 49,552 total)