Reply to thread

Message

<blockquote data-quote="Mew" data-source="post: 171767" data-attributes="member: 29012">Hi EvisTo clarify what kuehnch said:1 Open Microsoft SQL Server Management Studio Express2 In the left pane expand &quot;Databases&quot;3 Right click on &quot;TvLibrary&quot;4 Select &quot;Tasks&quot; &gt; &quot;Back Up...&quot;5 In the &quot;Back Up Database - TvLibrary&quot; window that pops up you should probably leave all the options as they are. You may however want to change the &quot;Destination&quot; by adding a new one and removing the default.6 Hit &quot;OK&quot; and it will create the backup file.If you need to restore a database:1 Open Microsoft SQL Server Management Studio Express2 In the left pane right click on &quot;Databases&quot;3 Select &quot;Restore Database...&quot;4 In the &quot;Restore Database -&quot; window that pops up you will need to specify the &quot;TvLibrary&quot; database using the drop down in the &quot;Destination for restore&quot; &quot;To database:&quot; 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 &quot;...&quot; button to specify the file and location.5 Hit &quot;OK&quot; 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 helpsMew</blockquote>

[QUOTE="Mew, post: 171767, member: 29012"] 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. [B][COLOR="Red"]Warning:[/COLOR][/B] 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 [/QUOTE]

Verification