Cant restore database

[EliteWarrior]

Hm who is using sql 2008? I cant seem to restore the billing database,account database restores succesfull but billing does not work.


Any one stumped to this error to and how did you fix it?

[janvier123]

mssql db's are not backwards compatible
but if your running mssql 2008 your should be fine
but i recommend that you use 2005, it maybe less secure and ****
but it does not need so high system specs

[freeskier4lif3]

Download the backup files from Janviers site, DKunderground. They work on 2000, 2005, and 2008.

Also, if you have a problem, it would help to explain the issue rather than just say it's not working. Is there an error message or anything?

[EliteWarrior]

I will try to use dkunderground files,error message will be posted later.
EDIT: Added screenshot of the error.

[janvier123]

all the "paths" ok when restore ?

[EliteWarrior]

yes they are i double checked them for some reason sql2008 restore path is automatically program files/sql2008/restore/ tried the old sql 2000 path like c:/billing.bak etc didnt work either,i gave up on sql2k8 and ur right janvier it uses wayyy to much system resources for only a sql server its to much 1 gig at idle time. Installing again swl2005 gonna stick with that one its pretty fast .

[janvier123]

dont use mssql 2000 with a Chinese back up
some chars have ???? inside them, good luck deleting them
mssql 2000 does not support those Chinese characters
unless you have some plug in or patch for it

[freeskier4lif3]

The problem is that another database is already using the file named billing.mdf in your default SQL backup folder.

When restoring the database, change the location of billing.mdf to "C:/billing.mdf" and then run the restore. You change the location under the "restore as" section on that screen shot you posted.

[janvier123]

restore as "C:/billing.mdf"
who cares if its in "C:/" ?

[freeskier4lif3]

It doesn't matter where, just as long as it's not in the same folder with the other "billing.mdf" which is being used by a different database. C:\ is just an example to make it easier for him/her

[EliteWarrior]

You didnt read well i said i already tried the standard location for restores wich is c:\ still doesnt work. Thanks for help to,ive deleted sql 2008 and im using sql 2k5. Looking to add anti sql injection to the databases