Unanswered: i cant set directory for backup database.
after selecting the presetted directory .. i clicked ok and they said this," The file name specified is recongnized as a directory name. The file won't be able to be rewritten. Would you like to continue? "
then i clicked " Yes " .. - nothing happened ..
then i clicked " Yes " .. - nothing happened again ..
now i click ok again to close the "restore database" icon .. and they give me this.. i attached a screenshot .. pls have a look ..
i tried clicking "Manage Attachments" somewhere at the bottom of the page to upload .. but ragezone gave me a page telling me that they are sorry for any inconvenience caused .. so i cant attach it .. here is a link .. its kinda small .. but it says:
"Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\'. Device error or device off-line. See SQL Server error log files for more details. RESTORE DATABASE is terminating abnormally."
no, you don't need a new folder, you need a filename. For example the complete path would be "e:\data\database\full_backup.bak", where "e:\data\database" would be your directory and "full_backup.bak" your filename.
my default directory was "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP"
inside "BACKUP" is NOTHING .. so what do i add into the directory now ? ..
i tried putting this .
"C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\full_backup.bak"
where "full_backup.bak" is actually not in my "BACKUP" folder ..
the same error appeared ..
"Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\full_backup.bak'. Device error or device off-line. See SQL Server error log files for more details. RESTORE DATABASE is terminating abnormally."
you are now mixing up two things. First you have to create a backup by specifying a filename before you can restore it.
This image is a screen during restore of the database. I presume now that you already have a backup. You have to know where it is and select it. If you only used default settings, it should be in the "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP". If there is no file there, your backup did not succeed.
what happens if click on the three dots after the directory? This directory should contain the file of the backup. If not, then either your backup is somewhere else and you have to browse to it or your backup did not succeed in which case you can't restore the database.
So the first thing you have to do now is either to locate your backup or to create a backup.