April 21, 2010 at 2:46 am
Hi
I use office accounting 2009 for my buisiness. I need to reinstall windows as I am using the trial version of windows 7 still. I remember not to long ago having trouble after something similar and losing databases from sql and not being able to restore the accounts. What will i need to backup before I reinstall.
Thanks In Advance
Any info welcome
Dave
April 28, 2010 at 9:55 am
If I am correct, Office Accounting uses SQL Server as database. So, you can always backup that database and then can restore it (though i have never done it, so here I am just guessing). If you have seperate machine, then you can try this by taking backup from your original machine and then restoring it on your test machine, in that way you eliminate chances of messing up with your data. (i did same with one POIS system of friend of mine)
You can find many help about how to backup and restore database. Basic script will be something like,
Backup Database <db_name>
To Disk = 'C:\testPlace\db_name.bak'
and then restore that file on your test system
Restore Database <db_name>
From Disk='C:\testPlace\db_name.bak' <--- Folder name is not essentially same as it is on another system
I hope this helps
Jack
April 28, 2010 at 6:38 pm
I think you'll find this useful (for the sql server backup piece).
http://msdn.microsoft.com/en-us/library/ms187510.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply