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,...
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...
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
May 17, 2010 at 5:48 am
Please do. I'd be very interested in the reason for this odd scenario.
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...
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
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/
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...
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.
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...
May 17, 2010 at 3:49 am
Nothing. It's just the naming standard that MS used in the adventureworks database.
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...
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
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...
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...
May 17, 2010 at 1:03 am
Viewing 15 posts - 32,836 through 32,850 (of 49,552 total)