|
View Poll Results: How often do you back up your database
|
Daily, I am a good BESAdmin woo hoo
|
|
17 |
85.00% |
More than Daily, I have SLA's to meet!
|
|
2 |
10.00% |
Never, I like to live on the edge and never RTFM.
|
|
1 |
5.00% |
Whats a database? Time for a new job?
|
|
0 |
0% |
|
|
03-09-2009, 08:55 AM
|
#1
|
BlackBerry Elite
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
|
Do you backup your database? SQL or MSDE
Please Login to Remove!
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter
Rocking the Motion with out lotion.
|
Offline
|
|
03-09-2009, 09:01 AM
|
#2
|
Feeling Blue, Bigly ;->
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
|
Quote:
Originally Posted by knottyrope
|
Mate you really are obsessed aren't you? We so have to find some work for you knotty
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
|
Offline
|
|
03-09-2009, 09:01 AM
|
#3
|
Thumbs Must Hurt
Join Date: Feb 2006
Model: 8330
Carrier: Verizon
Posts: 142
|
Twice a day - it's on a SQL server, so the backups are scheduled!!! Hooray!!
__________________
8330 4.5.0.77 OS - PIN: 303297df
BES Admin:
5x4.1.6 Exchange - 700 Users
"Sink or Swim" Educated
|
Offline
|
|
03-09-2009, 09:03 AM
|
#4
|
Feeling Blue, Bigly ;->
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
|
Quote:
Originally Posted by kpoland
Twice a day - it's on a SQL server, so the backups are scheduled!!! Hooray!!
|
Thing is, you can schedule them regardless of what the DB system is, so you have to really worry about anyone who just does them manually as and when.....
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
|
Offline
|
|
03-09-2009, 09:05 AM
|
#5
|
New Member
Join Date: Jul 2007
Location: In a van down by the river.
Model: NOTE2
OS: 4.1
PIN: <- Where do I find this?
Carrier: Sprint
Posts: 15,104
|
No beer or vodka options *look of disappointment*
SQL is backed up nightly.
|
Offline
|
|
03-09-2009, 09:08 AM
|
#6
|
BlackBerry Elite
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
|
Quote:
Originally Posted by stuwhite
Mate you really are obsessed aren't you? We so have to find some work for you knotty
|
Me, never.
What is work? I play all day long here.
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter
Rocking the Motion with out lotion.
|
Offline
|
|
03-09-2009, 09:10 AM
|
#7
|
BlackBerry Elite
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
|
Quote:
Originally Posted by jsconyers
No beer or vodka options
|
That will be needed while
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter
Rocking the Motion with out lotion.
|
Offline
|
|
03-09-2009, 09:10 AM
|
#8
|
Thumbs Must Hurt
Join Date: Feb 2006
Model: 8330
Carrier: Verizon
Posts: 142
|
Quote:
Originally Posted by stuwhite
Thing is, you can schedule them regardless of what the DB system is, so you have to really worry about anyone who just does them manually as and when.....
|
Yeah, I suspected as much. But I don't know a thing about MSDE, and the SQL guy wouldn't touch it unless it was on a SQL box.
Long, long ago I used to do manual MSDE backups.
__________________
8330 4.5.0.77 OS - PIN: 303297df
BES Admin:
5x4.1.6 Exchange - 700 Users
"Sink or Swim" Educated
|
Offline
|
|
03-09-2009, 09:16 AM
|
#9
|
Feeling Blue, Bigly ;->
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
|
Quote:
Originally Posted by kpoland
Yeah, I suspected as much. But I don't know a thing about MSDE, and the SQL guy wouldn't touch it unless it was on a SQL box.
Long, long ago I used to do manual MSDE backups.
|
Scheduled tasks and batch files my friend, the saviour of the sysadmin
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
|
Offline
|
|
03-09-2009, 09:17 AM
|
#10
|
Talking BlackBerry Encyclopedia
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
|
Backup daily to a file which is then FTP'd to our file server, all via script and windows Task Scheduler, which is backed up to tape overnight.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
|
Offline
|
|
03-09-2009, 12:31 PM
|
#11
|
CrackBerry Addict
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
|
I use this:
Free SQL Server database backup, Zip and FTP software
It backs up, ftps and sends email success/failure reports.
I do it daily - used to use Backup Exec but we're using SQL Express 2008 and the BE agent doesn't support it for this version.
|
Offline
|
|
03-09-2009, 03:18 PM
|
#12
|
Talking BlackBerry Encyclopedia
Join Date: May 2007
Location: Boston
Model: 8900
OS: 5.1
PIN: N/A
Carrier: AT&T
Posts: 285
|
WTF is a backup?
|
Offline
|
|
03-09-2009, 03:44 PM
|
#13
|
BlackBerry Elite
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
|
Quote:
Originally Posted by BBHorrigan
WTF is a backup?
|
I hope you do not do anything important in the IT field.
Answer here for the search challenged.
define:backup - Google Search
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter
Rocking the Motion with out lotion.
Last edited by knottyrope; 03-09-2009 at 05:39 PM..
|
Offline
|
|
03-10-2009, 12:41 AM
|
#14
|
Thumbs Must Hurt
Join Date: May 2008
Location: Manila, Phils
Model: 8320
PIN: N/A
Carrier: Smart Communications PH
Posts: 97
|
actually we do it weekly with the Symantec Backup Exec 12
|
Offline
|
|
03-10-2009, 07:32 AM
|
#15
|
BlackBerryForums.com Super Moderator
Join Date: Sep 2007
Location: Florida
Model: 9650
OS: 6.0.0.280
PIN: I heard it drop!
Carrier: VZW BIS
Posts: 6,534
|
I just got a batch file that Backups up the 3 database, MDSS, BESMGMT, MDSS_DIS, along with the BES folder including the State DB's and etc.. Then the Batch file copies it to a network drive...
(One of these days I will add some compression in there, to make the file transfer easier...)
__________________
8830 -> 8330 -> 9550 -> 9650
Just think about how far BlackBerries have come from then till now... And what else is coming.
Follow me on Twitter
|
Offline
|
|
03-10-2009, 07:36 AM
|
#16
|
New Member
Join Date: Nov 2007
Model: 8830
PIN: N/A
Carrier: Verizon
Posts: 14
|
I backup my SQL DB once a day
|
Offline
|
|
03-10-2009, 09:30 AM
|
#17
|
BlackBerry Elite
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
|
Quote:
Originally Posted by cyberkamote
actually we do it weekly with the Symantec Backup Exec 12
|
I had a backup fail on 10D and now use SQL to backup to flat file instead.
What a waste of money for the SQL connector.
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter
Rocking the Motion with out lotion.
|
Offline
|
|
03-10-2009, 09:33 AM
|
#18
|
Feeling Blue, Bigly ;->
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
|
Quote:
Originally Posted by TargetIT
|
Dude, what a nice app! Running on both BESs now, nice one!
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
|
Offline
|
|
03-10-2009, 09:50 AM
|
#19
|
Talking BlackBerry Encyclopedia
Join Date: Apr 2008
Location: Western NY, USA
Model: iPn4S
OS: iOS 7.0.1
PIN: 76E5A626
Carrier: Verizon
Posts: 243
|
We have an operations department that handles backups and such. The database is on our main SQL server and all the databases get backed up each night.
__________________
Technical Engineer III
BES was decommissioned. Currently using iPhones with Lotus Notes Traveler 9.0.
|
Offline
|
|
03-10-2009, 10:54 AM
|
#20
|
CrackBerry Addict
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
|
Quote:
Originally Posted by stuwhite
Dude, what a nice app! Running on both BESs now, nice one!
|
Thanks - I write batch scripts for almost everything I do but when I found this that literally does everything I need it to do, I was hooked.
|
Offline
|
|
|
|