Reply to thread

Message

I use MS SQL server 2005.

Stop the TVservice.

Log into the database by using "MS SQL server management studio express".

It asks for user credentials. Log in

Now expand the databases tree.
Now u should see the tvlibrary database.
Right click and select tasks->backup.
From there on it should be obvious.

When u have to restore, just delete the "faulty" tvlib DB.
U do this by right clicking on it, and selecting "delete".
Once deleted, u can now restore the backup copy.

Right click on the databases tree and choose"restore database".

Start the TVservice.

That's it.

/Gibman

<blockquote data-quote="gibman" data-source="post: 129319" data-attributes="member: 25430">I use MS SQL server 2005.Stop the TVservice.Log into the database by using &quot;MS SQL server management studio express&quot;.It asks for user credentials. Log in <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Now expand the databases tree.Now u should see the tvlibrary database.Right click and select tasks-&gt;backup.From there on it should be obvious.When u have to restore, just delete the &quot;faulty&quot; tvlib DB.U do this by right clicking on it, and selecting &quot;delete&quot;.Once deleted, u can now restore the backup copy.Right click on the databases tree and choose&quot;restore database&quot;.Start the TVservice.That's it./Gibman</blockquote>

[QUOTE="gibman, post: 129319, member: 25430"] I use MS SQL server 2005. Stop the TVservice. Log into the database by using "MS SQL server management studio express". It asks for user credentials. Log in :) Now expand the databases tree. Now u should see the tvlibrary database. Right click and select tasks->backup. From there on it should be obvious. When u have to restore, just delete the "faulty" tvlib DB. U do this by right clicking on it, and selecting "delete". Once deleted, u can now restore the backup copy. Right click on the databases tree and choose"restore database". Start the TVservice. That's it. /Gibman [/QUOTE]