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
> >>
> >
> >
> >.
> >

Backup

We are running SQL Server 2000, SP3. Do we need to stop SQL service before
backing up all the database (master, msdb, etc.)?
Thanks.No, SQL Server has always allowed you to back up a database while the server
is running.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
news:#TVYkJfZDHA.4020@.tk2msftngp13.phx.gbl...
> We are running SQL Server 2000, SP3. Do we need to stop SQL service
before
> backing up all the database (master, msdb, etc.)?
> Thanks.
>|||Thank you, Kalen.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uaBGjNfZDHA.1280@.tk2msftngp13.phx.gbl...
> No, SQL Server has always allowed you to back up a database while the
server
> is running.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
> news:#TVYkJfZDHA.4020@.tk2msftngp13.phx.gbl...
> > We are running SQL Server 2000, SP3. Do we need to stop SQL service
> before
> > backing up all the database (master, msdb, etc.)?
> >
> > Thanks.
> >
> >
>

Backup

We are using Legato backup - do I have to stop the sql database (service) to
be able to do a backup ? Is it anything I need to stop/start to have a ba
ckup taken ?
Rgds
MortenNo, you can do backups while people are using the server, although you
should schedule normal backups during periods of low activity...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"2Net SCA" <2net.sca@.schlumberger.com> wrote in message
news:24FED35B-4BFD-42B0-873C-EB72D063076E@.microsoft.com...
> We are using Legato backup - do I have to stop the sql database (service)
to be able to do a backup ? Is it anything I need to stop/start to have a
backup taken ?
> Rgds
> Morten

Backup

We are using Legato backup - do I have to stop the sql database (service) to be able to do a backup ? Is it anything I need to stop/start to have a backup taken ?
Rgds
Morten
No, you can do backups while people are using the server, although you
should schedule normal backups during periods of low activity...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"2Net SCA" <2net.sca@.schlumberger.com> wrote in message
news:24FED35B-4BFD-42B0-873C-EB72D063076E@.microsoft.com...
> We are using Legato backup - do I have to stop the sql database (service)
to be able to do a backup ? Is it anything I need to stop/start to have a
backup taken ?
> Rgds
> Morten

Backup

We are using Legato backup - do I have to stop the sql database (service) to be able to do a backup ? Is it anything I need to stop/start to have a backup taken ?
Rgds
MortenNo, you can do backups while people are using the server, although you
should schedule normal backups during periods of low activity...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"2Net SCA" <2net.sca@.schlumberger.com> wrote in message
news:24FED35B-4BFD-42B0-873C-EB72D063076E@.microsoft.com...
> We are using Legato backup - do I have to stop the sql database (service)
to be able to do a backup ? Is it anything I need to stop/start to have a
backup taken ?
> Rgds
> Morten

Backing up Windows Server with SQL server installed

I'm trying to find a way to shutdown the SQL server service on a Windows
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris IThis is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>

Backing up Windows Server with SQL server installed

I'm trying to find a way to shutdown the SQL server service on a Windows
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris I
This is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>

Backing up the Services Master Key

What happens if you don't backup the Service Master Key, or don't know where
the backup is? Will this keep you from restoring the Master Database? How
does this backup play in the disaster recovery?Hi
"DBA GUY" wrote:
> What happens if you don't backup the Service Master Key, or don't know where
> the backup is? Will this keep you from restoring the Master Database? How
> does this backup play in the disaster recovery?
Check out
http://blogs.msdn.com/lcris/archive/2005/07/08/sql-server-2005-a-look-at-the-master-keys.aspx
and other posts on the blog. The absolute worse case will be that you won't
be able to access the encrypted data in any of your databases, but if you
know the passwords to the DMKs you can drop the SMK encryption and re-apply
it.
John

Backing up the Services Master Key

What happens if you don't backup the Service Master Key, or don't know where
the backup is? Will this keep you from restoring the Master Database? How
does this backup play in the disaster recovery?
Hi
"DBA GUY" wrote:

> What happens if you don't backup the Service Master Key, or don't know where
> the backup is? Will this keep you from restoring the Master Database? How
> does this backup play in the disaster recovery?
Check out
http://blogs.msdn.com/lcris/archive/2005/07/08/sql-server-2005-a-look-at-the-master-keys.aspx
and other posts on the blog. The absolute worse case will be that you won't
be able to access the encrypted data in any of your databases, but if you
know the passwords to the DMKs you can drop the SMK encryption and re-apply
it.
John

Backing up the Services Master Key

What happens if you don't backup the Service Master Key, or don't know where
the backup is? Will this keep you from restoring the Master Database? How
does this backup play in the disaster recovery?Hi
"DBA GUY" wrote:

> What happens if you don't backup the Service Master Key, or don't know whe
re
> the backup is? Will this keep you from restoring the Master Database? Ho
w
> does this backup play in the disaster recovery?
Check out
http://blogs.msdn.com/lcris/archive.../>
r-keys.aspx
and other posts on the blog. The absolute worse case will be that you won't
be able to access the encrypted data in any of your databases, but if you
know the passwords to the DMKs you can drop the SMK encryption and re-apply
it.
John