Yea no worries mate - you can execute these statements in query analyzer

Cheers


Andy Hurst
SQL Server DBA
DBA Team, Technical Systems Group





"ROMAN KRUCZKOWSKI "
<mssqldba-ezmlmshield-x97603737.[Email address protected]
29/12/2006 14:06

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Re: How to Backup DB







Can you please give me instructions and I'm still in learning process.
Thank You.


----- Original Message ----
From: Andy Hurst <mssqldba-ezmlmshield-x8126187.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Thursday, December 28, 2006 9:42:40 PM
Subject: Re: How to Backup DB


USE master
EXEC sp_addumpdevice 'disk', 'demoBackupDevice',
'\\yourOrganisation.com\someDirectory\test29122006.bak'
go
BACKUP DATABASE master TO demoBackupDevice

Should do the trick!! (though I would recommend backing up to locally
attached drive/SAN first then moving to network drive in the first
instance)


Andy Hurst
SQL Server DBA
DBA Team, Technical Systems Group





"ROMAN KRUCZKOWSKI "
<mssqldba-ezmlmshield-x11914835.[Email address protected]
29/12/2006 13:07

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
How to Backup DB







Hello,
I need to know if there is a way to backup SQL database to network mapped
drive? How this can be done?
Roman


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


All mail is subject to content scanning for possible violation of New
South Wales Police
electronic Mail Policy. All persons are required to familiarise themselves

with the
content of the policy located on the NSWP Intranet BULLETIN BOARD.




This message and any attachment is confidential and may
be privileged or otherwise protected from disclosure. If you
have received it by mistake, please let us know by reply
and then delete it from your system; you should not copy
the message or disclose its contents to anyone.




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


All mail is subject to content scanning for possible violation of New
South Wales Police
electronic Mail Policy. All persons are required to familiarise themselves
with the
content of the policy located on the NSWP Intranet BULLETIN BOARD.




This message and any attachment is confidential and may
be privileged or otherwise protected from disclosure. If you
have received it by mistake, please let us know by reply
and then delete it from your system; you should not copy
the message or disclose its contents to anyone.



MS Sql Server LazyDBA home page