Problem in SQL

abady100 · 07/21/2011, 11:20

hi
I have a problem in SQL specifically back up

Ranma014 · 07/21/2011, 11:39

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

abady100 · 07/21/2011, 11:49

I tried to change the name and move it to C, but not useful

abady100 · 07/21/2011, 12:51

؟

abady100 · 07/21/2011, 13:48

Wat Dir@@?

abady100 · 07/21/2011, 19:56

I want to solve ~~

abady100 · 07/21/2011, 23:20

The size of the image server?

rattexxl · 07/22/2011, 14:45

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.

Ranma014 · 07/22/2011, 15:15

Quote:

Originally Posted by rattexxl

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)

rattexxl · 07/22/2011, 22:36

Ranma014 , da ich immer in Deutsch schreibe und schreiben werde kannst du es ja übersetzen. Das hilft besser als mich darauf hinzuweisen.

Cieldaron · 07/23/2011, 13:23

Quote:

Originally Posted by rattexxl

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.