June 25, 2014 at 9:03 am
Hi,
I am actually very new to SQL databases, I have received an .MDF and .LDF for a database of size 50 GB
I need to create or attach these files to a new database and extract some columns then convert them to .text or .csv
can anyone help
Thanks in advance
June 25, 2014 at 9:11 am
BOL (Books Online) explains how to do this.
http://msdn.microsoft.com/en-us/library/ms190209.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 25, 2014 at 9:18 am
Thanks for your reply, but when I try to do this I get an error because of the size of the database it is 50 GB and it allows a 10 gb max.
I purchased the ms sql 2014 from microsoft and I don't know why it is not installed as a full version ,
I tried to upgrade but I cannot locate the product key
June 25, 2014 at 9:23 am
eng.sarah.kandil (6/25/2014)
Thanks for your reply, but when I try to do this I get an error because of the size of the database it is 50 GB and it allows a 10 gb max.I purchased the ms sql 2014 from microsoft and I don't know why it is not installed as a full version ,
I tried to upgrade but I cannot locate the product key
I assume you have SQL Express installed? There is a limitation of 10GB. You will need a full version installed to use a database larger than 10GB.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 25, 2014 at 1:06 pm
Thank you very much
I uninstalled the express edition and installed the enterprise one and I was able to attach my database 🙂
Thanks again
June 25, 2014 at 1:09 pm
eng.sarah.kandil (6/25/2014)
Thank you very muchI uninstalled the express edition and installed the enterprise one and I was able to attach my database 🙂
Thanks again
You are welcome. Glad you were able to get it working.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply