BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-11-2009, 09:52 AM   #21 (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

Please Login to Remove!

Quote:
Originally Posted by TargetIT View Post
Just thought I'd add that here's a freeware version with email notification as well as rotating your backups out:

Free SQL Server database backup, Zip and FTP software

Very easy to use.
Quote:
Originally Posted by dcomiskey View Post
Very odd thing happened. For some reason this script - which was working perfectly fine for months - all of a sudden stopped working on 4/1 and hasn't run since. When I double-click on teh script the window just flashes and nothing happens. I'm not even getting any errors in the Event Viewed, which doesn't help me.

Any ideas on what to try?

EDIT: I'm trying to manually run osql -E in the command prompt and I'm getting "'osql' is not recognized as an internal or external command, operable program or batch file."

Uh-oh....

Edit 2: In looking back at that day, the server crashed and there's a chance that's when I re-installed BES.
dcomiskey I would suggest moving to this tool if you can. I moved to it at the start of the year and haven't looked back. Free and scriptless .
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-11-2009, 10:06 AM   #22 (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

And it ZIPs as well, personally it quartered the amount of sapce needed for backup.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 05-11-2009, 10:31 AM   #23 (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 DavidAdams View Post
And it ZIPs as well, personally it quartered the amount of sapce needed for backup.
ditto, they are tiny now!!
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-11-2009, 12:58 PM   #24 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2009
Model: n/a
PIN: N/A
Carrier: n/a
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Grr. I am trying to set it up. I can test the connections fine, but I am getting the error: Failed to retrieve databases from the SQL server. Invalid object name "sys.databases."
Offline  
Old 05-11-2009, 01:37 PM   #25 (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 think you've got corruption issues then - sys.databases contains, you guess it, a list of databases contained in server/session. Time to pull out SQL Manager and see what you can and can't see.
Offline  
Old 05-12-2009, 09:20 AM   #26 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2009
Model: n/a
PIN: N/A
Carrier: n/a
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by TargetIT View Post
I think you've got corruption issues then - sys.databases contains, you guess it, a list of databases contained in server/session. Time to pull out SQL Manager and see what you can and can't see.
I connected to the server from our main SQL server and am able to see the database and was even able to back it up. I'm extremely un-knowledgeable when it comes to SQL, so instructions for dummies could help me further. Do I want to repair the BES database or am I looking for something else?
Offline  
Old 05-12-2009, 09:43 AM   #27 (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

Are you running sqlbackupandftp from the SQL Server machine? It doesn't support remote backups at this time.
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-12-2009, 09:45 AM   #28 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2009
Model: n/a
PIN: N/A
Carrier: n/a
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by stuwhite View Post
Are you running sqlbackupandftp from the SQL Server machine? It doesn't support remote backups at this time.
No, I was trying to run it on the BES server itself.
Offline  
Old 05-12-2009, 09:50 AM   #29 (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 dcomiskey View Post
No, I was trying to run it on the BES server itself.
There you go, it will only work from the SQL Server machine. But it moves the files to somewhere else if you like, very neat
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-12-2009, 09:54 AM   #30 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2009
Model: n/a
PIN: N/A
Carrier: n/a
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

But the database resides on the BES server. There's no connection between it and our main SQL server. There's the instance of SQL running on the BES machine that's installed when you install BES. I only enlisted the help of the main SQL box (it's only for our accounting and CRM) to see if I could successfully connect to the BES database. I can't seem to find any SQL managers on the BES server, so that's why I did it.
Offline  
Old 05-12-2009, 10:04 AM   #31 (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

In which case install the software on your BES and run it there.

You shouldn't need any SQL managers on the BES, all you need is the name of the SQL instance on your BES, in my case it is PC-NAME\SQLEXPRESS.

Supply it the credentials to login to the SQL and then connect. It will then list the databases it finds, BESMgmt being the one you are looking for. Tick the box and fill in any details on the RHS of the dialogue.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 05-12-2009, 10:49 AM   #32 (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

He was running it from the BES originally unfortunately, so it looks like you might be back to DB corruption dcomiskey, as Target said
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-12-2009, 10:51 AM   #33 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2009
Model: n/a
PIN: N/A
Carrier: n/a
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by stuwhite View Post
He was running it from the BES originally unfortunately, so it looks like you might be back to DB corruption dcomiskey, as Target said
Any tips on how to fix that?
Offline  
Old 05-12-2009, 10:54 AM   #34 (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 dcomiskey View Post
Any tips on how to fix that?
Sorry dude, beyond my SQL server knowledge, time for the DBAs . Make sure you get a backup asap though, so at least you have your BES db intact if something goes wrong. OK so you don't need to use this app but it sounds like there might be issues needing a fix anyway.
__________________
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.