a db backup to a different machine

Question

Post reply

a db backup to a different machine

salma-398171

SSC Enthusiast

Points: 144
More actions
April 6, 2009 at 2:54 am

#203211

hello every one please help me quickly.......
I want to backup a db to a different machine ,
the sql stmt i run is:
(backup database Update_Master_Khasm to disk='\\10.1.5.250\Khasm\igmastback'
go )
Update_Master_Khasm is the db i want to backup
\\10.1.5.250\Khasm\igmastback' is the path and it have a permission th access from everyone as full control
so,
the error was (Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\10.1.5.250\Khasm\igmastback'. 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.
)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

the sql stmt i run is:
(backup database Update_Master_Khasm to disk='\\10.1.5.250\Khasm\igmastback'
go )
)

Hi Salma,

In the above query you have missed the Backup File Name. Please add the file name and the backup will succeed !

e.g. backup database Update_Master_Khasm to disk='\\10.1.5.250\Khasm\igmastback\BackupFileName.bak'

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

salma-398171 SSC Enthusiast Points: 144 More actions · Answer 2

Thanks Adiga for your help ,

but 'igmastback' is the filename

i have used it as itis onece

and another one as 'igmastback.bak'

Adiga One Orange Chip Points: 27284 More actions · Answer 3

Looks like the user with which you have logged on to SQL Server, does not have access to the path. Please check the User Permission on this share and also double check whether the share has "FULL" access enabled for this user.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Salma

you may want to include brackets around the database name too like so

backup database [Update_Master_Khasm] to disk = '\\10.1.5.250\Khasm\igmastback'

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

rajiniforu Ten Centuries Points: 1147 More actions · Answer 5

Hi,

The query being used holds good, .bak extention is an option and is not Mandatory.

backup database Update_Master_Khasm to disk='\\10.1.5.250\Khasm\igmastback'

go

However please check the following:

>> If the account running the query has the required permission to the network path

>> if 'igmastback' is the filename and not the folder name

>> Though it is an filename chk if a folder with the same name does not exists on the given path.

-Rajini

salma-398171 SSC Enthusiast Points: 144 More actions · Answer 6

Thanks alot every one :

the problem was related to the sqlsrvr account permissions