Backing Up Channel Groups, How?

EViS · 2007-08-14, 09:19

How can I backup my channel groups in case I need to reformat my HDD? Sorting 300 channels took an awfully long time and I don't fancy doing it again... Are these all stored in an .ini somewhere?

kuehnch · 2007-08-14, 11:02

Backup the TVServer-Database, that stores all settings of tvserver.
If you use SQLServer(-Express), you are able to do a backup by using Microsofts ManagementStudio (rightklick on the tvlibrary-database on the left tree and you will see maintaining-options like backup,restore...

After a reinstall of your system, you can get back all your settings/lists/sortings/groups.... by restoring the database, that you have stored before.

EViS · 2007-08-14, 21:50

How do I backup the database?

Mew · 2007-08-14, 23:31

Hi Evis

To clarify what kuehnch said:

1 Open Microsoft SQL Server Management Studio Express
2 In the left pane expand "Databases"
3 Right click on "TvLibrary"
4 Select "Tasks" > "Back Up..."
5 In the "Back Up Database - TvLibrary" window that pops up you should probably leave all the options as they are. You may however want to change the "Destination" by adding a new one and removing the default.
6 Hit "OK" and it will create the backup file.

If you need to restore a database:

1 Open Microsoft SQL Server Management Studio Express
2 In the left pane right click on "Databases"
3 Select "Restore Database..."
4 In the "Restore Database -" window that pops up you will need to specify the "TvLibrary" database using the drop down in the "Destination for restore" "To database:" if it exists. If it does not I believe it will create it. You also need to amend the Source for restore to From device and select the "..." button to specify the file and location.
5 Hit "OK" and it should retore the database.

As with all backups it is best to try it out, say on another PC if you have one before you need to use it in anger.

I have successfully used backup and restore when changing my HTPC from XP Pro SP2 to Vista. I took a backup before I started, reformated the harddrive and installed Vista and then restored the database.

Warning:
Bear in mind this is a backup of every tablein the database. If you recover it will give you a snapshot at the point you took the backup. This means your EPG may be out of date as well as the list of recorded programs if they have changed (which I guess they would daya to day).

I hope this helps

Mew

Marcusb · 2007-08-15, 01:16

hey Mew, thanks for such a detailed explanation

One further thing is that the backup may still not be useful if the structure changes due to MP enhancements.
If you upgrade an SVN and MP tells you the database has to be recreated, then this wont help.

I'm pretty sure that the backup option in the TV Channels section of the tv server will back up groups too, but I don't use groups so cant say for sure.

Safest option is to use both methods

2007-08-14, 09:19	#1 (permalink)
EViS Portal Member Join Date: Sep 2006 Posts: 157 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	Backing Up Channel Groups, How? How can I backup my channel groups in case I need to reformat my HDD? Sorting 300 channels took an awfully long time and I don't fancy doing it again... Are these all stored in an .ini somewhere?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Children Protection / PIN CODE in Channel Groups	chrissooo	General Support	0	2007-05-02 16:13
Pincode for channels / channel groups?	klunde	General Support	0	2006-10-25 13:33
MyTV: Channel Groups not working properly	Koschel	0.2.0.0 Release Candidate 1 CVS Bugs	2	2005-12-18 14:56
Radio Channel Groups	dhanjel	Improvement Suggestions	0	2005-07-28 15:57

2007-08-14, 11:02	#2 (permalink)
kuehnch Portal Member Join Date: Jun 2006 Location: Cologne (Köln) Age: 27 Posts: 303 Thanks: 3 Thanked 9 Times in 5 Posts Country:	Backup the TVServer-Database, that stores all settings of tvserver. If you use SQLServer(-Express), you are able to do a backup by using Microsofts ManagementStudio (rightklick on the tvlibrary-database on the left tree and you will see maintaining-options like backup,restore... After a reinstall of your system, you can get back all your settings/lists/sortings/groups.... by restoring the database, that you have stored before.

2007-08-14, 21:50	#3 (permalink)
EViS Portal Member Join Date: Sep 2006 Posts: 157 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	How do I backup the database?

2007-08-14, 23:31	#4 (permalink)
Mew Portal Member Join Date: Jan 2007 Location: Hertfordshire Age: 37 Posts: 191 Thanks: 8 Thanked 11 Times in 8 Posts Country: My System	Hi Evis To clarify what kuehnch said: 1 Open Microsoft SQL Server Management Studio Express 2 In the left pane expand "Databases" 3 Right click on "TvLibrary" 4 Select "Tasks" > "Back Up..." 5 In the "Back Up Database - TvLibrary" window that pops up you should probably leave all the options as they are. You may however want to change the "Destination" by adding a new one and removing the default. 6 Hit "OK" and it will create the backup file. If you need to restore a database: 1 Open Microsoft SQL Server Management Studio Express 2 In the left pane right click on "Databases" 3 Select "Restore Database..." 4 In the "Restore Database -" window that pops up you will need to specify the "TvLibrary" database using the drop down in the "Destination for restore" "To database:" if it exists. If it does not I believe it will create it. You also need to amend the Source for restore to From device and select the "..." button to specify the file and location. 5 Hit "OK" and it should retore the database. As with all backups it is best to try it out, say on another PC if you have one before you need to use it in anger. I have successfully used backup and restore when changing my HTPC from XP Pro SP2 to Vista. I took a backup before I started, reformated the harddrive and installed Vista and then restored the database. Warning: Bear in mind this is a backup of every tablein the database. If you recover it will give you a snapshot at the point you took the backup. This means your EPG may be out of date as well as the list of recorded programs if they have changed (which I guess they would daya to day). I hope this helps Mew

2007-08-15, 01:16	#5 (permalink)
Marcusb Super Moderator Join Date: Feb 2005 Location: Melbourne Posts: 1,909 Thanks: 61 Thanked 27 Times in 27 Posts Country: My System	hey Mew, thanks for such a detailed explanation One further thing is that the backup may still not be useful if the structure changes due to MP enhancements. If you upgrade an SVN and MP tells you the database has to be recreated, then this wont help. I'm pretty sure that the backup option in the TV Channels section of the tv server will back up groups too, but I don't use groups so cant say for sure. Safest option is to use both methods