Transferring to New Server


Transferring to New Server

Author
Message
Simon Davies
Simon Davies
Forum Sage
Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)

Group: Forum Members
Posts: 75, Visits: 1.9K
Hi,

Here at HRB we are moving to a new Server.

What SQL file do I need to move?

Once done, is it just a case of pointing all the play-out machines at the new server?

Thanks,
Simon.
David Boulton
David Boulton
Brand Manager - Broadcast Radio
Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)Brand Manager - Broadcast Radio (134K reputation)

Group: Broadcast Radio
Posts: 562, Visits: 74K
Hi Simon,

in SQL you can perform a database backup to a file - these can then be restored in the new SQL Server instance.

Right click over the individual databases and choose Tasks>backup


Regards

David Boulton
Brand Manager
Broadcast Radio Ltd
Simon Davies
Simon Davies
Forum Sage
Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)

Group: Forum Members
Posts: 75, Visits: 1.9K
David Boulton - Monday, March 19, 2018 12:38:26 PM
Hi Simon,

in SQL you can perform a database backup to a file - these can then be restored in the new SQL Server instance.

Right click over the individual databases and choose Tasks>backup

Can I do this with Myriad still running?


Peter Jarrett
Peter Jarrett
Forum Sage
Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)

Group: Broadcast Radio
Posts: 1.8K, Visits: 3.7K
Hi Simon,

Yes absolutely Smile


------------
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


Simon Davies
Simon Davies
Forum Sage
Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)

Group: Forum Members
Posts: 75, Visits: 1.9K
When I try and point the playout computers at the new server I get this error.

I think it is the same problem when I first set up the old sever. I had to get you (P Squared) to remotely log in and fix it. Can you remember what you did?


Peter Jarrett
Peter Jarrett
Forum Sage
Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)Forum Sage (370K reputation)

Group: Broadcast Radio
Posts: 1.8K, Visits: 3.7K
Are you running SQL Server or SQLServer Express? You might need to change the servername to SERVER2018\SQLExpress 

------------
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


Simon Davies
Simon Davies
Forum Sage
Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)Forum Sage (15K reputation)

Group: Forum Members
Posts: 75, Visits: 1.9K
Hi Peter,

We are running SQL server.

I think I am getting closer to fixing this? I have opened the port on the firewall. But still get an Login in error. Anyone have any ideas to fix that one?

Thanks,
Simon.
Matt Wade
Matt Wade
Forum Sage
Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)Forum Sage (69K reputation)

Group: Forum Members
Posts: 297, Visits: 876
Simon Davies - Monday, April 09, 2018 3:32:48 PM
Hi Peter,

We are running SQL server.

I think I am getting closer to fixing this? I have opened the port on the firewall. But still get an Login in error. Anyone have any ideas to fix that one?

Thanks,
Simon.

Hi Simon,

I may be completely wrong but do you not need to have a database instance name after the name of the server as Peter mentioned above so  Server2018\Instancename. Also make sure the security login (windows authenication vs sql authenication) is set correctly.

Wonder whether something on this page will help - https://dougrathbone.com/blog/2013/11/18/testing-connectivity-to-microsoft-sql-server-without-any-tools-installed



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


Reading This Topic


Login
Existing Account
Email Address:


Password:


Select a Forum....





























Broadcast Radio Forums


Search