Running Media manager on back end server

farss wrote on 10/1/2005, 4:48 PM

I guess the topic says it all, has anyone done this?
Seems to me a lot of the negative press would be avoided by hiving the SQL Server off to another machine optimised for the task. This has got to be a great way to work for anyone with multiple edit bays.
Bob.

Comments

Spot|DSE wrote on 10/1/2005, 5:45 PM

I could be wrong, Bob, but it sure looks like Media Manager might be heading in that direction.

Chienworks wrote on 10/2/2005, 2:41 PM

It would be a logical development. SONY certainly has gotten a substantial number of requests for it. From my own SQL programming experience it seems like it would be as easy as copying the database to that server and having a preference field to specify the server name, with "localhost" keeping it on your own local PC. Unless SONY has some funky implementation of SQL then this should be a very doable thing.

farss wrote on 10/2/2005, 3:16 PM

I've only had a brief brush with SQL Server from uSoft and from how that worked out I think by default it'll pretty much do this out of the box, certainly I had no problem moving the server to a backend on the target system. In fact one of the problems I did find with SQL Server is it's continually polling looking for things to 'serve', killing it off proved to be quite difficult.
Bob.

FDelucia wrote on 10/2/2005, 4:24 PM

For a living, I'm actually a MS SQL server programmer - I noticed that VEGAS installed MSDE for the media manager - that was interesting...

But I found that I could not attach to the database with my SQL Client tools - has anyone here successfully done that?

I've actually crashed VEGAS when trying to copy/paste stuff from one project to the next - crashed the SQL media manager with duplicate key errors. I would really like to be able to get into the SQL database and see what's being stored and manipulate it.