TV-Server Config: Can not create database (1 Viewer)

k4m4

Portal Member
April 12, 2008
5
0
Home Country
Italy Italy
TV-Server Version: 1.0 RC1 Refresh

Hi,
after configuring the db connection for Tv-Server when i tried to open SetupTv.exe an error came up saying something like "Can not create database". By looking in the log file I saw that the program was trying to create a sql server file TvLibrary.mdf which was already there. I solved the problem by manually deleting the file and some tables in the master database.

I think that the file was there because of another (unsuccessful) installation of Tv-Server. Maybe a check should be added to see if the file is already in the folder?

I've attached the log.
Bye
 

infinite.loop

Retired Team Member
  • Premium Supporter
  • December 26, 2004
    16,163
    4,133
    127.0.0.1
    Home Country
    Austria Austria
    i know what you mean.

    if you uninstall the SQL server without deleting the TVLibrary db first, then TvLibrary.mdf will stay in place and cause issues if you install the SQL-Server in the same path again later on.

    somehow i consider this to be a bug in the SQL-server, because "why" doesnt it overwrite the file? :confused:
     

    rtv

    Retired Team Member
  • Premium Supporter
  • April 7, 2005
    3,622
    301
    Osnabruck
    Home Country
    Germany Germany
    Correct. We can only check the master table for information regarding any existing DB. If that tells us "there's nothing here" we have to assume MSSQL does tell the truth as your primary filestorage/partitioned tables/etc could be placed everywhere.
     

    Users who are viewing this thread

    Top Bottom