[callumacrae]

I would strongly recommend using an alternative database server such as MySQL.

Failing that, try a reinstall.

[TheEmpty]

deucalion0, on 03 November 2011 - 04:54 PM, said:

I need to use it for my university coursework and I am pulling my hair out. can anyone please tell me why this happening? i would really appreciate some advice before this laptop goes out the window.

Well first off it's not the laptop.

callumacrae, on 03 November 2011 - 05:41 PM, said:

I would strongly recommend using an alternative database server such as MySQL.

He said that he needed to use it for school.

I would google the error code and your problem, I don't think too many people use Microsoft SQL Server.

[Daniel15]

Are you using SQL Server Management Studio? If so, are you sure you're connecting to the right instance every time? On my computer it's .\SQLEXPRESS. Perhaps you have more than one instance and are connecting to a different instance every time.

Could you take a screenshot when you get an error again, and post it here?

Quote

I would strongly recommend using an alternative database server such as MySQL.

Why? Microsoft SQL server has a lot of features that either aren't implemented or are very poorly implemented in MySQL (MySQL's stored procedures are nowhere near as good as SQL Server's). If anything, I'd suggest PostgreSQL as it's probably the closest open-source equivalent to SQL Server.

[TheEmpty]

Yes, PostgreSQL is my favorite DB, I've never use SQL Server though. (Just vouching on D's post that PostgreSQL is fucking awesome [his words not mine [no]])

[deucalion0]

Hey guys thanks for the input, I tried googling the error code but it brings back results where people have had issues trying to attach a database created on a different version of sql server, I think the version before R2, I simply am trying to get my database back, as it was there the day before and not the next. As I mentioned before, the next day i opened SQL server, my database had returned. As for different instances, I only have one instance created.

I just tried to attach the database which is in the folder where all the databases are for that instance and here is the error I get:


TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'RAYMOND-LAPTOP'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.....0+((KJ_RTM_GDR).110422-1901+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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

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

The database 'TutorialTwo' cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported.
Could not open new database 'TutorialTwo'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)


I need to use this heap of crap for my coursework, but I spend more time trying to get it to work than I do actually doing something productive.

any further help is appreciated guys.

Thanks

[Daniel15]

This is why companies that use SQL Server have dedicated DBAs o_O

Did you see this blog post?

Quote

the user is trying to attach a SQL Server 2008 R2 database (v. 661) to an SQL Server 2008 SP2 instance. This is not supported. User has to either upgrade the SQL Server 2008 SP2 instance to SQL Server 2008 R2, or it has to attach the database back to a R2 instance and copy out the data from the database into SQL Server 2008 instance database, eg. using the Import and Export Wizard.

Have you installed or removed any patches recently? Try installing all updates from Windows Update.

Apart from that, I don't have any other suggestions... Sorry . I'm still learning a lot about SQL Server.