SQL Server Enterprise 2008 R2 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Server Enterprise 2008 R2

Author

Topic

phimtau123
Starting Member

6 Posts

Posted - 2012-02-16 : 17:19:10

Does anyone know where i can download a trial version of SQL Server 2008 R2 Enterprise? or is there a way to copy and restore database from a Sql Server 2008 R2 to a SQL Server 2008 Enterprise?

When I tried to restore a database froom SQL server 2008 R2 to SQL Server 2008 Enterprise, I got a incompatible error.

Any help is appropriate, Thank you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-16 : 17:36:58

You can't restore from R2 to R1. You can get a trial version on microsoft.com.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

phimtau123
Starting Member

6 Posts

Posted - 2012-02-16 : 21:47:35

i been trying to find the trial version all day and could not find the enterprise R2 edition. I could only find the R1. Can you please provide the link?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-17 : 04:23:53

Google: SQL 2008 R2 evaluation. 2nd link:
http://msdn.microsoft.com/en-us/evalcenter/ff459612

--
Gail Shaw
SQL Server MVP

phimtau123
Starting Member

6 Posts

Posted - 2012-02-17 : 11:29:47

this is the regular edition not the enterprise?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-17 : 12:59:45

There is only one edition that's available for trial, sometimes called evaluation edition. It's DataCenter edition (the top, top edition), with a 180 day time limit on it.

The link on that page that says "Review Microsoft SQL Server 2008 R2 system requirements" goes to a page that, right at the top, says
"SQL Server 2008 R2 Datacenter is available for evaluation during a 180-day trial period."

--
Gail Shaw
SQL Server MVP

phimtau123
Starting Member

6 Posts

Posted - 2012-02-17 : 15:33:26

thank you for confirming that. I will give it a try. One more question does the evaluation edition have native partitioning function?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-17 : 17:40:48

Evaluation is completely equivalent in features to Data Centre edition.

--
Gail Shaw
SQL Server MVP

phimtau123
Starting Member

6 Posts

Posted - 2012-02-17 : 22:29:41

thank you for your help. I've installed the edition and are doing some upgrade to our environment. We've run into the following error when trying to run a script that would update our database schema and data to a new database schema. This is for upgrade from HP bac to HP bsm. I've create the user and gave it sysadmin role and test the connection and all is working well. The upgrade script wont work and I've find these error. Do you know what this mean? or where i can start looking to debug this?

012-02-17 18:09:56,128 [pool-2-thread-2] (DBUGenericSqlActionRunner.java:302) INFO - Exploring entire schema
2012-02-17 18:09:56,892 [pool-2-thread-2] (DBUGenericSqlActionRunner.java:427) WARN - Can't find Table queue_messages_1977058079 for FileGroup: PRIMARY
2012-02-17 18:09:56,892 [pool-2-thread-2] (DBUGenericSqlActionRunner.java:427) WARN - Can't find Table queue_messages_2009058193 for FileGroup: PRIMARY
2012-02-17 18:09:56,892 [pool-2-thread-2] (DBUGenericSqlActionRunner.java:427) WARN - Can't find Table queue_messages_2041058307 for FileGroup: PRIMARY
2012-02-17 18:09:56,892 [pool-2-thread-2] (DBUGenericSqlActionRunner.java:427) WARN - Can't find Table filestream_tombstone_2073058421 for FileGroup: PRIMARY
2012-02-17 18:09:56,892 [pool-2-thread-2] (DBUGenericSqlActionRunner.java:427) WARN - Can't find Table syscommittab for FileGroup: PRIMARY
2012-02-17 18:09:59,778 [pool-2-thread-2] (DBUCorrectionEventRunnerSqlSolutionFormater.java:133) DEBUG - No default db user was found for MSSQL, using default: dbo
2012-02-17 18:09:59,778 [pool-2-thread-2] (DBUCorrectionEventRunnerSqlSolutionFormater.java:133) DEBUG - No default db user was found for MSSQL, using default: dbo
2012-02-17 18:09:59,903 [pool-2-thread-2] (DBUCorrectionEventRunnerSqlSolutionFormater.java:133) DEBUG - No default db user was found for MSSQL, using default: dbo
2012-02-17 18:09:59,903 [pool-2-thread-2] (DBUCorrectionEventRunnerSqlSolutionFormater.java:133) DEBUG - No default db user was found for MSSQL, using default: dbo
2012-02-17 18:09:59,903 [pool-2-thread-2] (DBUCorrectionEventRunnerSqlSolutionFormater.java:696) DEBUG - SQL formatter: filegroup - userdata001
2012-02-17 18:09:59,903 [pool-2-thread-2] (DBUCorrectionEventRunnerSqlSolutionFormater.java:696) DEBUG - SQL formatter: filegroup - userdata001

Thank you for your time!!!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-18 : 04:55:08

Without seeing the script that caused those, no.

--
Gail Shaw
SQL Server MVP

phimtau123
Starting Member

6 Posts

Posted - 2012-02-21 : 01:39:02

figured out what was causing the problem.

Thank you so much for your help :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources