Mike Mattys
mmattys at rochester.rr.com
Wed Mar 25 18:30:40 CDT 2009
OK - database works ... rebuilding my Suppliers stuff - Michael R Mattys MapPoint and Database Dev www.mattysconsulting.com - ----- Original Message ----- From: "Mike Mattys" <mmattys at rochester.rr.com> To: "Salakhetdinov Shamil" <mcp2004 at mail.ru>; "Discussion concerning Visual Basic and related programming issues." <dba-vb at databaseadvisors.com> Sent: Wednesday, March 25, 2009 7:17 PM Subject: Re: [dba-VB] SCRUM: Invalid Columns >I found this to help me out: > SQL Services Manager > http://www.sqldbatips.com/showarticle.asp?ID=46 > > - > Michael R Mattys > MapPoint and Database Dev > www.mattysconsulting.com > - > ----- Original Message ----- > From: "Salakhetdinov Shamil" <mcp2004 at mail.ru> > To: "Discussion concerning Visual Basic and related programming issues." > <dba-vb at databaseadvisors.com> > Sent: Wednesday, March 25, 2009 6:36 PM > Subject: Re: [dba-VB] SCRUM: Invalid Columns > > >> Mike, >> >> You can stop MS SQL Server service in Services or just reboot your PC. >> >> When that solved delete current version of .mdf, then copy one from >> archive and attach it again and then restore db from backup using replace >> option. >> >> Note: published backup has several backup versions - please use the >> latest >> one. >> >> To help you to solve the issue I have just uploaded current db files and >> backup - you can just attach .mdf - backup is to restore db if you'll >> make >> some changes you wanted to overwrite back. >> >> >> The archive is at MS LIve dba-VB: >> >> https://cid-000971dc34dc18c0.groups.skydrive.live.com/browse.aspx/.Documents/NorthWind.NET/Database?view=details >> >> named >> >> NorthwindNET_DB_and_backup_20090326.zip >> >> Thank you. >> >> -- >> Shamil >> >> P.S. Falling asleep here CU tomorrow....