Backup Strategy

My client has about 2TB data, are there any recommended
backup strategy? Does SAN / NAS helps?Hi,
The best method for 2 TB database will be,
1. Perform a Diffrential Backup daily once
2. Perform a Transaction Log backup every 30 Minutes (U can change based on
daily growth)
Since the volume is very huge ideal way to keep the backup devices will be
either SAN or NAS.
Thanks
Hari
MCDBA
"Peter Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:0a8d01c3d9a9$d97e0140$a101280a@.phx.gbl...
> My client has about 2TB data, are there any recommended
> backup strategy? Does SAN / NAS helps?|||You might also take a look at filegroup backups, which are intended for very
large databases. These are doc'd in books on line... You might have to move
data around into new filegroups to implement this, but it would allow you to
back up part of the database each night...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Peter Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:0a8d01c3d9a9$d97e0140$a101280a@.phx.gbl...
> My client has about 2TB data, are there any recommended
> backup strategy? Does SAN / NAS helps?sql

Backup Strategy

My client has about 2TB data, are there any recommended
backup strategy? Does SAN / NAS helps?Hi,
The best method for 2 TB database will be,
1. Perform a Diffrential Backup daily once
2. Perform a Transaction Log backup every 30 Minutes (U can change based on
daily growth)
Since the volume is very huge ideal way to keep the backup devices will be
either SAN or NAS.
Thanks
Hari
MCDBA
"Peter Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:0a8d01c3d9a9$d97e0140$a101280a@.phx.gbl...

quote:

---

> My client has about 2TB data, are there any recommended
> backup strategy? Does SAN / NAS helps?

---

|||You might also take a look at filegroup backups, which are intended for very
large databases. These are doc'd in books on line... You might have to move
data around into new filegroups to implement this, but it would allow you to
back up part of the database each night...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Peter Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:0a8d01c3d9a9$d97e0140$a101280a@.phx.gbl...

quote:

---

> My client has about 2TB data, are there any recommended
> backup strategy? Does SAN / NAS helps?

---

sql

Backup Oddity

A client needed to put in there own backup (without using
the Database Maintence Plan) I won't go into the reasons
but it was correct.
Anyway they asked us to find a safe way of deleting the
internal records and the files, hence me.
I have found something pretty odd. The sp_dropdevice does
not delete the records in the msdb tables backupset or
backupmediafamily why is this the case ?
Thanks
JYou would have to ask the MS programmers that wrote sp_dropdevice why it
doesn't delete the backup history. It might have been a conscious decision,
it might have been that they just didn't do this when backup history tables
changed structure between 6.5 and 7.0. It is always difficult to answer
"why" question if you weren't present MS design. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:ed7d01c40c36$12470cb0$a401280a@.phx.gbl...
> A client needed to put in there own backup (without using
> the Database Maintence Plan) I won't go into the reasons
> but it was correct.
> Anyway they asked us to find a safe way of deleting the
> internal records and the files, hence me.
> I have found something pretty odd. The sp_dropdevice does
> not delete the records in the msdb tables backupset or
> backupmediafamily why is this the case ?
> Thanks
> J|||Thanks Tibor,
Now I don't need to trawl though BOL to see if I have
missed anything :-D
J

>--Original Message--
>You would have to ask the MS programmers that wrote
sp_dropdevice why it
>doesn't delete the backup history. It might have been a
conscious decision,
>it might have been that they just didn't do this when
backup history tables
>changed structure between 6.5 and 7.0. It is always
difficult to answer
>"why" question if you weren't present MS design. :-)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ed7d01c40c36$12470cb0$a401280a@.phx.gbl...
using
does
>
>.
>|||A tip, Julie:
Read the source code for the procedure in question. Reading the source code
for sp_dropdevice, I see that there is no code in there to remove backup
history, so there is no need to look any further. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:ecfd01c40c39$8ee0e8b0$a301280a@.phx.gbl...
> Thanks Tibor,
> Now I don't need to trawl though BOL to see if I have
> missed anything :-D
> J
>
>
> sp_dropdevice why it
> conscious decision,
> backup history tables
> difficult to answer
> message
> using
> does|||Again thanks Tibor,
J

>--Original Message--
>A tip, Julie:
>Read the source code for the procedure in question.
Reading the source code
>for sp_dropdevice, I see that there is no code in there
to remove backup
>history, so there is no need to look any further. :-)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ecfd01c40c39$8ee0e8b0$a301280a@.phx.gbl...
reasons
the
or
>
>.
>

Backup in MSDE

Hello, I need to to a create a SQL Server 2000 job to perform a backup for a
client. They're running Small Business Server 2003. I went on the machine
and I don't see Enterprise Manager. I see that there is a SQL Server
directory with mdf and ldf files. Does this mean that ther're running MSDE,
if so how can you create jobs to run backups if you don't have Enterprise
Manager?
ThanksHi, Don
You can create jobs using sp_add_job, sp_add_job_step,
sp_add_job_schedule and sp_add_job_server. You can execute a T-SQL
script using OSQL. See Books Online for more informations. It may be
easier to see how Enterprise Manager calls these procedures, using
Profiler (on another computer with the full SQL Server installed).
Razvan