Hi All,

Just thought I'd add a little note about the Backup of SQL files.  There is a slight gotcha that it would be good to be aware of, as it may be something you only find at the point to need to try to restore a database.

Looking at the Back Up Database window in SQL Server Management Studio you have a section that allows you to select the Destination for the back ups which will let you add several file locations to the backup set.  This is not, as you may expect, going to create several independent backups which are all stand alone, rather this will split the backup over the files you have selected.  This means to restore the database you would need ALL of the files listed in the backup window and if any are missing, you have an invalid backup set.

The option to Mirror the backup set (which would create multiple separate backups) is not available in SQL 2008 R2 Express, but is available in the more powerful versions.  In Express it would probably be better to backup to a single file, as this could then be copied to another location to give you a second backup off the server.

It is very unlikely that the Myriad databases would ever get to the sort of size that would require you to split the backup over several devices or locations, so this should not really cause any problems with using a single file.

 For more info about creating backups, take a look at this MSDN page http://msdn.microsoft.com/en-us/library/ms187510(v=sql.105).aspx

Regards,

Andrew

It is highly recommend for an SQL setup that LOGS and DATABASES are on seperate physical drives for performance.

Hi Matt,

I'm not sure you should be taking advice from me

I can't imagine I'm the first to make the move from V3 to V4 on Windows 8

But that sequence of install did work for me.

As we are on the subject of SQL I wonder if anyone can offer some assistance with regard to the backup and restore of the Myriad/Autotrack SQL DATABASES?

The process is not quite as straight forward as the backup and restore of the old JET Database.

I have so far taught myself how to backup using the SQL server management studio. 

The four .bak files listed below are what I "suspect" I need (not sure if I need the system databases?)     

DATABASEv3-v40.bak

DirectorySQL.bak

Myriad4Data.bak

MYRIADLIB.bak

I would like to know if the backups are valid usable files, but I'm very nervous about the restore procedure.

Any help or advice would be most welcome.

Thanks

Rick 

Hi Rick,

Thanks for that info. So in summary when moving from Myriad v3 to v4 you would suggest in this order:-

1 - Install SQL server on server (configure it for multiple connections if you have a variety of workstations)

2 - Install Myriad Autotrack and import the existing autotrack database into it

3 - Install Myriad Playout and point it to the same SQL database and the correct audio file locations.

ta - M

Matt Wade
Need Training or Consultancy for Broadcast Radio Software Products?
Get in touch
w: https://mattwadeonline.co.uk
e: training@mattwadeonline.co.uk

Now Software licensing can be a minefield - so don't take this as gospel....

The CTXchange donations from Microsoft are mainly either 'Volume Licensing' or 'Software Assurance' licences.

Most MS Volume Licensing schemes have 'downgrade rights' built in which allow you to use an earlier version of the same product (i.e. I could buy some Windows 8 licences today, but then install Windows 7 - not sure on the rights for SQL server as no experience of that.).

This page:
http://www.microsoft.com/licensing/about-licensing/briefs/downgrade-rights.aspx
Has some information on downgrade rights.

--
Myriad user since 1998, now custodian of dozens of Myriad,Autotrack, Powerlog and Scoop boxes of many different flavours.
http://www.philedmonds.com

Life is full of surprises!

I purchased Myriad and Autotrack in 2002 (v2.5) and over the years I have installed, uninstalled, upgraded, moved to new hardware and recovered form dead hardware.

I thought installing Myriad 4 was going to be the easy bit and the SQL was going to be the challenge.

Wrong again!!!

After finding the correct version of SQL I followed all the other instructions and it was smooth sailing!

Windows 8 and MS SQL Express 2008R2 (with SP1) all happy together, the rest should be a doddle I thought.....

I realise the problem that followed may have been my fault, I will try to explain what happened.

The plan was to install Myriad and Autotrack on the C: drive and have the audio and system files in the D: drive (common practice for keeping the crown jewels away from the opperating system as you all know)

Not knowing how the SQLServer was going to work, I started by moving the \\Psquared\Audiowall folder from the old Myriad v3.6 machine to the D: Drive on the new machine.

Installed Myriad v4 with no problem and configured it in the usual way. A quick look on the cart wall to check the audio was ok, Happy Days!

Installed Autotrack v4 with no problem and configured in the usual way, tried, tried and tried again to import the old .mdb file no joy

DATABASEv3-v40 already exists was the error message

After several failed attempts I concluded that I was as much use as Stevie Wonder taking Ray Charles to the movies!

So to blind leading the blind, I tracked the location of the offending DATABASEv3-v40 and renamed it ( I can hear tech support laughing ) 

This commedy went on for hours, I can only guess that did someting wrong when installing Myriad because I did not create the DATABASEv3-v40 yet it was there.

System restore to before SQL.

Reinstalled SQL ok, this time I installed Autotrack first, pointed Autotrack to the D: drive, imported the v3 .mdb with no problems

Installed Myriad last.

And relax.....   

So a week after the install and no crashes yet

Rick

Hi Rick,

Thanks for that, I've now updated my post at the top with the new download link! Let us know of anything else you find

Cheers,

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

Rick,

that's really interesting and helpful information thanks

I'm sure that when we officially give Windows 8 the nod, we will update the forum posts with the correct links.

I know it's quite soon after you got SQL installed, but how's it going otherwise?

Regards

David Boulton
Brand Manager
Broadcast Radio Ltd

Just A Quick FYI

Having recently put Myriad 4 on a brand new Windows 8 machine (fool) I thought I'd share a finding with you.

The detailed SQL advice given by Peter might have been written with windows 7 in mind.

I followed the instructions to the letter and I watched the tutorial video, I was rewarded with a Microsoft message reporting a compatability issue.

Don't ya luv Windows!

Three more failed attempts (out of hours) forced me to speak to the god Google, woohoo!

It would seem that the above link to download SQL Express 2008R2 gives you the original release, previous versions of windows would accept it then let windows update it.

My install of Windows 8 was having none of it!

It demanded SQL Express 2008R2 and service pack 1 slipstreamed

http://www.microsoft.com/en-us/download/details.aspx?id=26729

Got there in the end

I was runningsql server 2005 with another application (mymovies)

After installing sql 2008 r2 I can get neither autotrack 4 or the other program to run.

My support subscription has also expired, so i assume i'm unable to contact tech support by phone?

any screenshots of what i should have seen on starting autotRACK FOR 1st time.

Help as always appreciated

Regards

Alex