Upgrading backend SQL Server database

[poweld1]

We currently have the lansweeper database on a SQL Server 2005 on Windows Server 2003, this server is being upgraded in the near future to run SQL Server 2008 R2 on Windows Server 2008 R2. I was wondering if there are any problems with at all with this setup?

[neosys]

Thanks for pointing out the disk space issue !

SOLVED

[Hemoco]

Is it possible that there is already a file : E:\SQL DATABASES\lansweeperdb.mdf
Or the disk is full?

[neosys]

Just ran the install on our SQL 2008 server (2008 R2 Server)
using domain admin + sa account for the SQL installation

I get a SQL 5149 error.

Then creating the DB manually does the same, any suggestions ?



TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Database 'lansweeperdb'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

MODIFY FILE encountered operating system error 112(failed to retrieve text for this error. Reason: 15105) while attempting to expand the physical file 'E:\SQL DATABASES\lansweeperdb.mdf'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5149)

[Hemoco]

I would recommend using windows 2008 R2 SP1

[poweld1]

Lansweeper wrote:
I would recommend using windows 2008 R2 SP1

We will most likely will, so no problems with having Lansweeper on SQL Server 2008 R2 then?

[Hemoco]

poweld1 wrote:

We will most likely will, so no problems with having Lansweeper on SQL Server 2008 R2 then?

No known problems