I have installed MS SSMSE 2008 and need local db to work with

Question

I installed the 2008 management console express and now want to install a db on my PC. It asks me to 'browse to the media files' as if it's asking for a disc. I don't have one since I downloaded the mgmt console.

How can I install a sql server express on my PC for a test system? My main db is at my ISP for my e-commerce site.

Thanks,

Allen

Answer 1

Hope this will help

http://msdn.microsoft.com/en-us/library/dd981045(v=sql.100).aspx

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

I went through this nightmare yesterday on the SQL Server 2012 download manager page, It starts extracting and then errors out with no error message

I am on Windows 7 64 bit

Answer 3

can you attach screen shot to show how it errors out ?

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 4

I have a snagit screenshot - I can't insert it

Answer 5



Answer 6

Hi allencunningham,

The error is about network. Please try again. Or you could download Microsoft SQL Server2008 R2 RTM - Express with Advanced Services as a replacement.

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 7

Thank you, I will try it tonight when I get off work

Answer 8

That worked,  the 2008 R2 version installed correctly, thanks

I now want to start working with my db that's up at my ISP. If I go up there and back it up, do you know what tool I would use to restore it into my local db ?

Thanks,

Allen

Answer 9

I now want to start working with my db that's up at my ISP. If I go up there and back it up, do you know what tool I would use to restore it into my local db ?

backup & restore.

you need to contact your ISP to get the information how you could get the data. If it is a ASP.NET database than you'll have the database files in your APP_DATA and you should be able to just download that file to your local disk and attach it to your SQL Server edition.

if you're using backup&restore or the attach method, you need to ensure that your SQL Server version is equal or higher than the one of your ISP otherwise you can't restore / attach the database due to higher version but as you've installed SQL 2008R2 locally it don't expect this to become an issue as it is very unlikely that your ISP is already using SQL 2012.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 10

Hello - I have the backup file and it is from a SS 2005 db.  I just need to know what tool to use in my local installation  to restore it into my local db. Do I use the SQL Server Import and Export wizard that i installed?

Or is it something in the 'Configuration tools folder?

If I have a backup file what is the next step to start working with it locally?

Do I use SS Management Studio to do the restore?

Thanks,

Allen

Answer 11

Hello - I have the backup file and it is from a SS 2005 db.  I just need to know what tool to use in my local installation  to restore it into my local db. Do I use the SQL Server Import and Export wizard that i installed?

start SQL Server Management Studio, connect to your SQL Server instance, click on the database node in Object Explorer and right click and select Task -> Restore Database, than select your backup file.

Don't forget to change the target path for the database files in the Options view.

Alternatively you could just execute a restore database command from a query window but than you need to know what to do - using SSMS is a guided restore.

see How to: Restore a Database Backup (SQL Server Management Studio)

and RESTORE (Transact-SQL)

als T-SQL wuerde es dann etwa so aussehen - Beispiel von MSDN:

RESTORE DATABASE TestDB 
   FROM AdventureWorks2008R2Backups 
   WITH MOVE 'AdventureWorks2008R2_Data' TO 'C:\MySQLServer\testdb.mdf',
   MOVE 'AdventureWorks2008R2_Log' TO 'C:\MySQLServer\testdb.ldf';

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 12

Thanks Daniel - I will give that a try

Answer 13

Daniel - I need to leave for a while before I try this. Could I get your email address if I have few more questions?

If so send to - [e-mail]

thanks,

Allen

Answer 14

Daniel - I downloaded my backup file from my ISP. The database name is 'awesomeart'. There is no awesomeart on my local machine, so i am giving it that name. I specified 'from device'and pointed to my backup file.

What am i doing wrong?

Thanks,  allen

Answer 15

Did you try other name than awesomeart ?

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 16

That's the name of the db, what other name should I give it ?

Answer 17

there should be an option where you can change the directory to which the database files (mdf/ldf) are beeing restored.

Or just use the script above and change the name for the database, the backup files and the directory.

To get the logical name just use the following code

RESTORE HEADERONLY
   FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSSQL.10_50_SQLEXPRESS\MSSQL\Backup\awesomart_db_20120428.bak'
WITH NOUNLOAD

(eventually you must use the correct path and filename) and use the logical name in the MOVE statement

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 18

OK - I ran the query and it worked. does that do the restore? I still don't see my db

Answer 19

no it give just the logical name which you need to specify in the RESTORE DATABASE

RESTORE DATABASE awesomeart
   FROM DISK = '<put path an name to your backup here>'
   WITH MOVE 'awesomeart_Data' TO 'C:\MySQLServer\awesomeart.mdf',
   MOVE 'awesomeart_Log' TO 'C:\MySQLServer\awesomeart.ldf';

please change the path&filename in the "TO ..." to your preferred location.

PS. please read the last posting in your other thread

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 20

What is awesomeart_Data ? What is awesomeart_log ?

What names should I use, where do I get them?

Answer 21

What is awesomeart_Data ? What is awesomeart_log ?

What names should I use, where do I get them?

replace those by the name you got from RESTORE HEADONLY output

xx.mdf: usually the database file for database xx containing the data of the database

xx.ldf: usually the transaction log for the database xx.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 22

I ran the query and it returned one row with a lot of fields, db name, server name, username, sort order, code page, etc, etc, etc

Which is supposed to have the data in it

Answer 23

I ran the query and it returned one row with a lot of fields, db name, server name, username, sort order, code page, etc, etc, etc

Which is supposed to have the data in it

use the following code to get the list of logical name in your backup

RESTORE FILELISTONLY
   FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.10_50_SQLEXPRESS\MSSQL\Backup\awesomart_db_20120428.bak'
WITH NOUNLOAD

(eventually you must  correct the path and filename) and use the names the column LogicalName  in the MOVE command of the RESTORE DATABASE statement

RESTORE DATABASE awesomeart
   FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL.10_50_SQLEXPRESS\MSSQL\Backup\awesomeart_db_20120428.bak'
   WITH MOVE 'awesomeart_Data' TO 'C:\MySQLServer\awesomeart.mdf',
   MOVE 'awesomeart_Log' TO 'C:\MySQLServer\awesomeart.ldf';

please change

'awesomeart_Data' to the value from the LogicalName from first command (Type=D)

'awesomeart_Log to  the value from the LogicalName from the first command (Type=L)

the path&filename in the "TO ..." to your preferred location.

if the FILELISTONLY delivers more than 2 rows you need to specify each of them in a MOVE.

If you still have problem, please list the output of first code block and specify the full name (path and filename) of your backup file and the directory where you want to put the database files into.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 24

had this issue now  been resolved?

Answer 25

Yes, now I am unable to attach, and the folder, mdf and ldf appear to have full control when I right click on them

any ideas?

Thanks,

Allen