"Noorali Issani" <naissani@softhome.net> wrote in message
news:%236fBEWQKEHA.808@tk2msftngp13.phx.gbl...
> How can I set the password on my database backup file.. I don't wanna use
> zip options...
>
> Any idea about encryption?
>
> Thanks
> NOOR
>
>

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:OOOHAMRKEHA.3292@TK2MSFTNGP11.phx.gbl...
> Hi Noor,
>
> Use the backup database command with PASSWORD option. Sample is shown
below;
>
> Backup database pubs to disk='c:\pubs.bak' with init,password='hari'
>
> While restorong if you are not giving the password the restore operation
> will fail with below error
>
> "Server: Msg 3279, Level 16, State 2, Line 1
> Access is denied due to a password failure
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally."
>
> How to restore with password
> ----------------------------------
>
> Restore database pubstest from disk='c:\hari.bak' with password='hari'
>
> Thanks
> Hari
> MCDBA
>
>
> "Noorali Issani" <naissani@softhome.net> wrote in message
> news:#6fBEWQKEHA.808@tk2msftngp13.phx.gbl...
> > How can I set the password on my database backup file.. I don't wanna
use
> > zip options...
> >
> > Any idea about encryption?
> >
> > Thanks
> > NOOR
> >
> >
>
>

"Noorali Issani" <naissani@softhome.net> wrote in message
news:OQDnRORKEHA.3492@TK2MSFTNGP09.phx.gbl...
> You are awesome Hari..
>
> Thanks alot
>
> Noor
>
> "Hari" <hari_prasad_k@hotmail.com> wrote in message
> news:OOOHAMRKEHA.3292@TK2MSFTNGP11.phx.gbl...
> > Hi Noor,
> >
> > Use the backup database command with PASSWORD option. Sample is shown
> below;
> >
> > Backup database pubs to disk='c:\pubs.bak' with init,password='hari'
> >
> > While restorong if you are not giving the password the restore operation
> > will fail with below error
> >
> > "Server: Msg 3279, Level 16, State 2, Line 1
> > Access is denied due to a password failure
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally."
> >
> > How to restore with password
> > ----------------------------------
> >
> > Restore database pubstest from disk='c:\hari.bak' with password='hari'
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> > "Noorali Issani" <naissani@softhome.net> wrote in message
> > news:#6fBEWQKEHA.808@tk2msftngp13.phx.gbl...
> > > How can I set the password on my database backup file.. I don't wanna
> use
> > > zip options...
> > >
> > > Any idea about encryption?
> > >
> > > Thanks
> > > NOOR
> > >
> > >
> >
> >
>
>

"Noorali Issani" <naissani@softhome.net> wrote in message
news:#6fBEWQKEHA.808@tk2msftngp13.phx.gbl...
> How can I set the password on my database backup file.. I don't wanna use
> zip options...
>
> Any idea about encryption?
>
> Thanks
> NOOR
>
>

"Noorali Issani" <naissani@softhome.net> wrote in message
news:e$bL5ZRKEHA.3592@TK2MSFTNGP09.phx.gbl...
> Let's assume I am restoring the database from Enterprise Manager so how
Can
> I restore ?
>
> Thanks
>
> NOOR
> "Noorali Issani" <naissani@softhome.net> wrote in message
> news:OQDnRORKEHA.3492@TK2MSFTNGP09.phx.gbl...
> > You are awesome Hari..
> >
> > Thanks alot
> >
> > Noor
> >
> > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > news:OOOHAMRKEHA.3292@TK2MSFTNGP11.phx.gbl...
> > > Hi Noor,
> > >
> > > Use the backup database command with PASSWORD option. Sample is shown
> > below;
> > >
> > > Backup database pubs to disk='c:\pubs.bak' with init,password='hari'
> > >
> > > While restorong if you are not giving the password the restore
operation
> > > will fail with below error
> > >
> > > "Server: Msg 3279, Level 16, State 2, Line 1
> > > Access is denied due to a password failure
> > > Server: Msg 3013, Level 16, State 1, Line 1
> > > RESTORE DATABASE is terminating abnormally."
> > >
> > > How to restore with password
> > > ----------------------------------
> > >
> > > Restore database pubstest from disk='c:\hari.bak' with
password='hari'
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > > "Noorali Issani" <naissani@softhome.net> wrote in message
> > > news:#6fBEWQKEHA.808@tk2msftngp13.phx.gbl...
> > > > How can I set the password on my database backup file.. I don't
wanna
> > use
> > > > zip options...
> > > >
> > > > Any idea about encryption?
> > > >
> > > > Thanks
> > > > NOOR
> > > >
> > > >
> > >
> > >
> >
> >
>
>