Backup device?

Hi all,
I want to store bakup file on the computer on netword, so make a backup device on the other computer, it ok. after that i make an full backup, there is an error : "Can not open the bakup device " .
please show me,
best regard.share that network PC drive and if u still have any problem login into both pc with same login id...

that will surely resolve ur problem..

Cheers!!|||Originally posted by thanhtung2003
Hi all,

I want to store bakup file on the computer on netword, so make a backup device on the other computer, it ok. after that i make an full backup, there is an error : "Can not open the bakup device " .
please show me,
best regard.
Make sure you have write permission in that folder.
Or create log on credential at that newwork PC.

Backup Database

HI

i have created job which executes following Store Procedure, my Qs is after 1-day has passed shldnt it overwrite , i mean i have 1-GB Database my job runs for 3-times a day so end of day i have 3-GB so wen time goes past 12.00 am shldnt it becomes 1-GB again

Alter Procedure sp_DBBackup as
BACKUP DATABASE [XYZ] TO
DISK = N'D:\Office Purpose\Database\Backups\XYZ\Backup-Method (Append-Expiry)\XYZ_Complete_Append.Bak'
WITH NOINIT ,
NOUNLOAD ,
RETAINDAYS = 1,
NAME = N'XYZ backup',
NOSKIP ,
STATS = 10,
NOFORMAT

No....you are using NOINIT so you are appending backups to the device. You would use RETAINDAYS to throw up an error message if you try to do an INIT and you do a NOSKIP meaning that it will check to see if you have any backups that aren't yet expired. If there are backups not yet expired, you get an error. That's about all RETAINDAYS does - it won't maintain your history for you - it just keeps you from overwriting.

-Sue

BACKUP - BCV

HI,
I am working with a DW and my costumer hired a service in
a colocation and we're using a STORAGE to store all data !
and he also contract a backup system called BCV that
connects to the storage that I'm using and then copy all
the information, but during this process he blocks all the
activity in the disk and syncronyze the information and
after that he releases the disk. I would like to know if
someone heard about it our work with it..
Thank's
Roberto CarrascoYes we use it. We use EMC and what basically happens is that it Freezes
your SQL Server IO and then thaws it. You will see this in the logs. We
use it on most of our systems and the process takes ~ 5 seconds. We have no
problems with it. it does not appear to affect replication or anything
(touch wood)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in message
news:09e201c37215$bfa001c0$a501280a@.phx.gbl...
> HI,
> I am working with a DW and my costumer hired a service in
> a colocation and we're using a STORAGE to store all data !
> and he also contract a backup system called BCV that
> connects to the storage that I'm using and then copy all
> the information, but during this process he blocks all the
> activity in the disk and syncronyze the information and
> after that he releases the disk. I would like to know if
> someone heard about it our work with it..
> Thank's
> Roberto Carrasco
>|||Nope you don't stop anything. The BCV/Symmetrix software handles
everything.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Roberto Carrasco" <Roberto_carrasco@.msn.com> wrote in message
news:120f01c37255$06d513c0$a401280a@.phx.gbl...
> Hi,
> Thank's for your reply ! Is necessary to stop the SQL
> SERVICE - Do I need to do something ' If I need to
> restore ! Do I have to STOP SQL SERVER SERVICE .
> Please ANswer
> Thank's
> Roberto Carrasco
> >--Original Message--
> >Yes we use it. We use EMC and what basically happens is
> that it Freezes
> >your SQL Server IO and then thaws it. You will see this
> in the logs. We
> >use it on most of our systems and the process takes ~ 5
> seconds. We have no
> >problems with it. it does not appear to affect
> replication or anything
> >(touch wood)
> >
> >
> >
> >--
> >
> >--
> >Allan Mitchell (Microsoft SQL Server MVP)
> >MCSE,MCDBA
> >www.SQLDTS.com
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >
> >"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in
> message
> >news:09e201c37215$bfa001c0$a501280a@.phx.gbl...
> >> HI,
> >> I am working with a DW and my costumer hired a service
> in
> >> a colocation and we're using a STORAGE to store all
> data !
> >> and he also contract a backup system called BCV that
> >> connects to the storage that I'm using and then copy all
> >> the information, but during this process he blocks all
> the
> >> activity in the disk and syncronyze the information and
> >> after that he releases the disk. I would like to know if
> >> someone heard about it our work with it..
> >>
> >> Thank's
> >>
> >> Roberto Carrasco
> >>
> >
> >
> >.
> >