(I only get the daily summary, so I apologize if this has
already been
answered)
I have heard numerous horror stories about using various
backup software
packages to back up a SQL database, and I wonder if that is
what really
went wrong.
SQL Server itself has a wonderful tool to back up data to a
file, and
then you can use backup software to backup the file.
Inside Enterprise Manager you can drill down to the database
you want to
backup, right click and select "All Tasks"
--> "Backup Database". You
can specify the name of the file and where it is located.
And there is
a section at the bottom of the window where you can schedule
the backup.
Make sure you also choose the correct option for your needs
between
appending data and overwriting data. I have also heard
horror stories
of people appending their backups until the file size of the
backup
became so large that there was not enough free space on the
server,
causing it to crash.
Hope that helps
-- Andy
-----Original Message-----
Message 5
From: "Joe Magueta" jm pcwe.ca
Date: Mon May 29, 2006 6:27am(PDT)
Subject: Methods of backing up CIMS and Raiser's Edge
A client of mine has had some bad experiences with Veritas
Backup Exec,
CIMS
and Windows 2000 Small Business Server. Her previous IT
person
explained to
her that because Backup Exec used SQL server it destroyed
the W2K SBS
installation and the whole thing had to be reinstalled.
Don't ask me
what
it means because when I try probing for more information I
always get
the
above explanation which doesn't really make sense to me,
because, the
version of BackupExec that they have (I think 8.5) does not
mention any
version of SQL as a requirement nor have I found any kind of
incompatibility
that would cause an entire server to become corrupt.
Anyway, to avoid
any
further problems I would like to ask the group which backup
methods have
been successful in the real world with CIMS and Raiser's
Edge.
They now have two servers, one is W2K SBS and the other is
W2K3
Enterprise
server R2. They may also end up removing the W2K SBS and
installing W2K
Server Standard if that would make things easier.
Suggestions appreciated.
Thanks
Joe
------------------------ Yahoo! Groups Sponsor
--------------------~-->
Get to your groups with one click. Know instantly when new
email arrives
http://us.click.yahoo.com/.7bhrC/MGxNAA/yQLSAA/26EolB/TM
------------------------------------------------------------
--------~->
=========================================
The Information Systems Forum is an opt-in, low-traffic,
flame-free distribution list for discussions of information
technology for nonprofit organizations.
To post a message, prepare a regular email and send it to
Information_Systems_Forum@yahoogroups.com
To join the Information Systems Forum, send a blank email to
Information_Systems_Forum-SUBSCRIBE@yahoogroups.com
To leave the Information System Forum, send a blank email to
Information_Systems_Forum-UNSUBSCRIBE@yahoogroups.com .
Please note that there may be a lag (of hours or days)
between the moment that you send the command and the moment
that you stop receiving messages from this group. Your list
administrator apologizes for this flaw in the YahooGroups
configuration, but has been unable to shorten the lag from
her end of things.
To send a message to the list administrator (Deborah), email
it to Information_Systems_Forum-owner@yahoogroups.com .
To view the message archive, go to http://groups.yahoo.com/group/Information_Systems_Forum
To participate in the unmoderated version of this email
distribution list, go to http://groups.yahoo.com/group/Information_Sy
stems_Forum_UNMODERATED/
To view a map of the group's membership, go to http://
www.frappr.com/informationsystemsforum
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Information_Systems_Forum/
<*> To unsubscribe from this group, send an email to:
Information_Systems_Forum-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.c
om/info/terms/
|