Broadcast Radio Forums


Backup database


Backup database

View Options
Author
Message
leejhowe
leejhowe
leejhowe
Posted 10 Years Ago
#7441
leejhowe
Forum Sage
Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)

Group: Forum Members
Posts: 2, Visits: 17
Hello!

We currently have Myriad v4 set up with a single database (On a dedicated server). We would like to set up a second server as a backup to this. Ideally, this server would replicate the main one and be selectable in Myriad in the case that server 1 failed. 

Is this possible? I can't seem to find any information anywhere on how this would work.

Thanks,
Lee Smile
Engineer - Bedrock Hospital Radio 
314
Reply
Craig Arthur
Craig Arthur
Craig Arthur
Posted 10 Years Ago
#7442
Craig Arthur
Forum Sage
Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)

Group: Forum Members
Posts: 258, Visits: 7K
I don't look after the underlying SQL servers, but from memory/conversations in the past the free version of SQL doesn't really offer an easy backup solution.

So long as you are a registered charity you can get the full SQL server with replication etc reasonably cheaply from CT exchange http://www.ctxchange.org/.

Craig Arthur

Engineering & IT Manager
Radio Royal, Royal 2 & Royal Gold.
277
Reply
leejhowe
leejhowe
leejhowe
Posted 10 Years Ago
#7444
leejhowe
Forum Sage
Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)Forum Sage (1.5K reputation)

Group: Forum Members
Posts: 2, Visits: 17
Thanks for your reply.

Funnily enough i'm just in the middle of registering with ctxchange.

Im ok (Ish) with the sql server stuff itself, The bit I need to find out is how myriad deals a backup server.

Thank you!
Lee Smile
284
Reply
Craig Arthur
Craig Arthur
Craig Arthur
Posted 10 Years Ago
#7446
Craig Arthur
Forum Sage
Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)Forum Sage (105K reputation)

Group: Forum Members
Posts: 258, Visits: 7K
Myriad can't backup itself, unlike the old V3 where Autotrack could be made to create database backups.  It has to be done with SQL. 

Craig Arthur

Engineering & IT Manager
Radio Royal, Royal 2 & Royal Gold.
283
Reply
GO


Post Quoted Reply

Reading This Topic

Login
Existing Account
Email Address:


Password:
Select a Forum....
  • Narrow your search by forum

Broadcast Radio Forums

Search
  • Narrow your search by forum
Jump To Page
Jump To Page