BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 03-18-2009, 11:25 AM   #1 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Jul 2008
Model: 7800
PIN: N/A
Carrier: Tmobile
Posts: 286
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Backup db on full SQL with osql

Please Login to Remove!

My BES database is on a full version of SQL 2000 server. Is it possible to use OSQL command line to backup the database? I know I can use Enterprise Manager to do a backup, but since I'm not the owner of the SQL server, I don't want to make any change on Enterprise Manager. Thanks
Offline  
Old 03-18-2009, 11:50 AM   #2 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

This is what I use:

Free SQL Server database backup, Zip and FTP software
Offline  
Old 03-18-2009, 12:06 PM   #3 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

I was using a scheduled script to backup and FTP but since this was pointed out I have installed it instead.

It just works, can't say anymore. Only caveat is that it has to be installed on the SQL server itself. Well the current version does anyway, the remote bit is currently being worked on.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone

Last edited by DavidAdams : 03-18-2009 at 12:08 PM.
Offline  
Old 03-18-2009, 12:20 PM   #4 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

I'm a little surprised that the "owner" of the SQL Server doesn't have a backup solution though.
Offline  
Old 03-18-2009, 06:43 PM   #5 (permalink)
Feeling Blue, Bigly ;->
 
stuwhite's Avatar
 
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
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by TargetIT View Post
I'm a little surprised that the "owner" of the SQL Server doesn't have a backup solution though.
Yeah definitly speak to your dba coz he should be backing up the db, not you. If he isn't doing it daily I would want to move my db somewhere else :->. And I can also vouch for that app, threw my scripts out a few weeks ago and never looked back .
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.