PLEASE HELP !!!!
-
Hi All
I would be most gratefull if someone could help me, or put me out of my misery. I use office accounting 2009 to run my small buisiness. I have just had to reinstall windows and saved a company backup . I know nothing about sql servers but realised I would have to keep hold of the databases to make my software run again after the reinstall. In my ultimate wisdom and pure lack of knowledge I copied the folders 80 , 90 , MSSQL.1 , MSSQL.2 and MSSQL.3 to another hard drive then after the reinstall copied them back over to where they should be. My Queastions are;
1) Am I anywhere near or am I barking up the wrong tree.
2) I assume if I am anywhere near I need to reattach these databases somehow if that is indeed what I have saved.
3) can anyone shed any light on my miserable mess.
Thanks In Advance
Much Appreiciated
-
search your MSSQL.1mMSSQL.2 and MSSQL.3 folders for *.mdf files.
with luck, one of those files should be the name of your old database.
once it, you will copy that MDF file along with it's matching LDF file to your new server.
then you will need to go to SSMS, right click on the database folder and Choose "Attqch..."
follow the prompt to browse to wherever you put the copies of the mdf/ldf pair.
after selecting them, it will verify whether the pair are corrupt; if they are not, you can just continue and it will attach them.
after that, you might have permission/connection problems for anyone who's not admin, but that will get you started.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Hi
Thanks for the quick reply and please ignore my ignorance but what is ssms . I have tryed to open microsoft sql server and all that is there is configuration tools with which I cannot seem to do anything. This version has only been installed along with my accounting software. Is it that I will need to download / install more sql software.
Thanks Again
-
SSMS = Sql Server Management Studio.. Invoke it, Open the Database Node and follow what Mr.Lowell had put in his post...Hope this helps you..
-
What was in the 'company backup'?
you say you reinstalled windows. did you reinstall SQL server?
Don't want to get too technical but if you have an MSSQL.1 and .2 and .3 you either 3 instances of SQL or the database engine, analysis services and reporting services, do you know which? (check the directories under these folders)
Do you see Sql management studio under SQL server 2005 in programs?
If you open configuration manger and select SQL services in the left pane, what is shown in the right pane?
seeing as you reinstalled the OS I would doubt SQL is installed and copying back those files is not enough to bring it back, but they contain files that will allow you to recreate your environment so don't lose them.
Please Post the exact process you followed when you rebuilt the server, without drowning us in detail.
---------------------------------------------------------------------
-
sorry just spotted you said SQL is installed as part of your application, must be SQL Express edition then. That does not come with SSMS but it can be downloaded from a link on this page (which tells you a bit about SQL express)
http://www.microsoft.com/sqlserver/2005/en/us/express.aspx
So how were your databases managed before?, via the app?
Still not sure why 3 instances installed though.
---------------------------------------------------------------------
-
Hi Guys
Thanks again for all the help . I have downloaded and installed ssms but still cant attach these databases. I have found a .mdf file about 150 mb but dont understand what you mean about copy it to my server. SScrazy I have not rebuilt the server at all I have simply reinstalled MS Acounting 2009 which installs SQL itself , I have then just copied my backup files across then tried to open a backup in my accounting program , but the backup will not launch, Im guessing because the databases do not exist. Sorry to be a novice I realise this must but difficult for you but I have no knowledge of servers just trying to use a basic bookkeeping package.
Thanks Again
Your help is warmly appreiciated.
-
Happy to help you , though the help was very little 🙂
-
David with luck this will get you oriented.
you need to open SQL Server Management Studio, and get the object explorer on the left side opened up; once you have that open and right click on the database folder to select "Attach"
You need to Attach a database by browsing to wherever the 150 meg mdf file is that you said you found.
click the add button,a dn a dialog similar to what you see below will open; by default it will have the same name it had before, so if there are no errors, you should be able to click "OK" and it should attach.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Thanks again for all your guidance. I have tried to do as you instruct but get the error message.
failed to recieve data for this request
operating system error 32(error not found) while attempting to open file.
I can see the name of the databases when I click on databse on ssms because I have dragged them to the right folder but they just will not attach.
Thanks Again
-
There is a support forum for Office Accounting at:
I'm understanding you're probably not using a server, this probably runs on one computer. You found a .mdf file, but was there also a .ldf file?
-
If you reinstalled you Accounting Program it should have created empty databases like it was before you started using the accounting system. If that is the case you will need to find out where they are stored on your computer and then detach them, keep a copy of them ( incase you need to backup), put you old files in their place and reattach the database.
-
jlennartz (4/27/2010)
If you reinstalled you Accounting Program it should have created empty databases like it was before you started using the accounting system. If that is the case you will need to find out where they are stored on your computer and then detach them, keep a copy of them ( incase you need to backup), put you old files in their place and reattach the database.that sounds quite possibly the problem , because you say you can already see the database in SSMS (which means it is already attached to SQL) and you get an error 32 trying to open the file (error 32 means file in use)
so yes, detach the database currently attached to SQL, but first of all right click on it, select all tasks and select backup database. This gives you another back out in case of problems. then detach the database, and then attach your old database files as the same database name. If you can find the old .ldf file as well all the better, if necessary though you should be able to attach the database without it.
---------------------------------------------------------------------
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply