Viewing 15 posts - 6,241 through 6,255 (of 19,560 total)
OK. This error is different than the prior error for which I provided a script.
It appears you are now trying to attach the DW database.
What is the file path...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 7:55 pm
The SP1 in your earlier reply is for the OS. SQL Server is at the release version still (RTM).
The database file you are trying to attach is SP1 and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 7:19 pm
Yes - please patch your instance from RTM to SP1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 7:00 pm
Try this to get the server level and sp level
select @@version
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 6:09 pm
New Horizons should be fine - most of it depends on the student and instructor.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:45 pm
based off the file location in PM
USE [master]
GO
CREATE DATABASE [AdventureWorks2008R2] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008R2_Data.mdf' )
FOR ATTACH
GO
Also, what is the service pack level of your Dev...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:44 pm
Is this person completely new to SQL?
If so, then New Horizons may be fine.
Otherwise, I would rather buy a book, computer, and play around with the samples in the book.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:42 pm
post the command you used
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:40 pm
I would look for R2 training (2012 would also be viable enough).
Also, consider looking for SQL Saturday events in your area.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:20 pm
Woot
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:17 pm
You didn't change the file path in the query like I pointed out.
That file path must be changed to reflect the location of where you placed the data file on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:17 pm
Why do you need SQL 2012 on the webserver?
Have you considered alternatives such as 2008 which would provide you a middle ground to jumping to SQL 2012?
http://www.microsoft.com/en-us/download/details.aspx?id=1695
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:13 pm
I have several clients running Accpac on SQL Server 2008 R2 as well as just SQL Server 2008. You should be ok with Accpac on SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:09 pm
Have you tried following this article?
http://msdn.microsoft.com/en-us/library/cc645923.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:07 pm
Use something like this:
USE [master]
GO
CREATE DATABASE [AdventureWorks2008R2] ON
( FILENAME = N'C:\Database\Data\AdventureWorks2008R2_Data.mdf' )
FOR ATTACH
GO
You will need to change your path. Once you execute that command, you should see...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2012 at 5:04 pm
Viewing 15 posts - 6,241 through 6,255 (of 19,560 total)