May 20, 2009 at 8:40 am
Hi All,
I am newbie in dba side. I have a question in backup. I had tried to backup the database in same machine which was server located. But i cant take backup it throws an error saying that
"Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:\New Folder'. Device error or device off-line. See the SQL Server error log for more details.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally."
If anyone helps its great.
Thanks in advance
Pras
May 20, 2009 at 8:44 am
aprasy (5/20/2009)
Hi All,I am newbie in dba side. I have a question in backup. I had tried to backup the database in same machine which was server located. But i cant take backup it throws an error saying that
"Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:\New Folder'. Device error or device off-line. See the SQL Server error log for more details.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally."
If anyone helps its great.
Thanks in advance
Pras
Not sure, but looks like it may be a permissions issue on the directory. SQL Server may not have the permissions necessary to write to the directory.
May 20, 2009 at 9:40 am
I am pretty sure it's because you specified a directory in the backup rather than a file. You need to name the actual file that you want to backup to:
Example:
C:\New Folder\Database.bak
A.J.
DBA with an attitude
May 20, 2009 at 9:49 am
By default sqlserver has a \backup folder in its installation directories.
It is being pointed to if you make a backup using the GUI (SSMS)
(object explorer / right click on the db name / tasks / backup)
The sqlserver service account needs write authority on the folder you want to write the backup to.
In many cases a c:\temp is write authorized to public 😉
for test:
Backup database yourdbname
to disk='c:\temp\yourdb_FULL.bak'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2009 at 10:06 am
Thanks a lot guys it works
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply