Problem in SQL

07/21/2011 11:20 abady100#1
hi
I have a problem in SQL specifically back up


[Only registered and activated users can see links. Click Here To Register...]
07/21/2011 11:39 Ranma014#2
You can try to remove all the special characters in the path, only use [a...z]&[0...9]
whcih means, put the backup in C:\ and name them Arcadia.bak , Auth.bak and Telecaster.bak
07/21/2011 11:49 abady100#3
I tried to change the name and move it to C, but not useful
07/21/2011 12:51 abady100#4
؟
07/21/2011 13:48 abady100#5
Wat Dir@@?
07/21/2011 19:56 abady100#6
I want to solve ~~
07/21/2011 23:20 abady100#7
The size of the image server?
07/22/2011 14:45 rattexxl#8
ich habe die erfahrung gemacht das auch wenn es unter c:\ liegt nicht geht.
Daher einfach unter C:\Programme\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup rein kopieren und siehte da es geht.
07/22/2011 15:15 Ranma014#9
Quote:
Originally Posted by rattexxl View Post
ich habe die erfahrung gemacht das auch wenn es unter c:\ liegt nicht geht.
Daher einfach unter C:\Programme\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup rein kopieren und siehte da es geht.
Ganz toll und jetzt nochma auf englisch, denn falls du es nicht mitbekommen haben solltest, spricht der user oben englisch (und die sprache die zu den schriftzeichen gehört)
07/22/2011 22:36 rattexxl#10
Ranma014 , da ich immer in Deutsch schreibe und schreiben werde kannst du es ja übersetzen. Das hilft besser als mich darauf hinzuweisen.:D
07/23/2011 13:23 Cieldaron#11
Quote:
Originally Posted by rattexxl View Post
I've experienced that it won't work if it's stored in C:\.
Therefore, just copy the backup(s) to "C:\programs\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup" and see how it's working.
My bad translation for you lol. (:

The filepath should be replaced with your filepath (including arabic letters ofc),
just the final location "Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup" has to be the same.

My backups worked fine with being stored in a separate folder in C:\ (means: "C:\backups").

If it won't work anyways, try resizing the files to 2 MB instead of 3 (this was the reason why my first backups weren't restorable...).

Therefore, right click on the EMPTY(!) database and choose "Tasks/Shrink/Files".

There should the option "Release unused space" be ticked.
Choose "Reorganize pages before releasing unused space" and enter
2 MB instead of 3 MB into the field "Shrink files to: X MB (Minimum is X MB)"

Then click on Ok an repeat this step with the two other EMPTY databases.

After you've finished this, you may restore the databases.
Also you need to have the option "OVERWRITE EXISTING DATABASE" enabled.

It is in the options if you restore a database.