Running a downloaded sql file on my computer

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 Programming

Running a downloaded sql file on my computer

Author

Topic

lamboguy
Starting Member

3 Posts

Posted - 2011-11-20 : 11:05:04

Hi Folks,

I have an online sql database file I have downloaded to my computer.

How can I run this file on my computer?

Thanks,

Fred

Fred

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-20 : 11:51:24

you need to open the management studio, connect to server, right click on databases and select restore database, then select option from device and browse to file on your computer and click ok. it should attach the db to server and on refreshing you should be able to explore it.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

lamboguy
Starting Member

3 Posts

Posted - 2011-11-20 : 16:45:38

Thank you. I don't have management studio. What's the best way to get it? I see Microsoft makes it -- Management Studio Express -- is that the one I want?

Fred

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-20 : 23:41:36

yes. you can use Management studio express also. try the above steps in it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

jassi.singh
Posting Yak Master

122 Posts

Posted - 2011-11-21 : 01:39:51

Hi,

Check this link to attach your file
http://msdn.microsoft.com/en-us/library/ms190209.aspx

johntech
Yak Posting Veteran

51 Posts

Posted - 2011-11-21 : 06:31:50

visakh16 you need to open the management studio, connect to server, right click on databases and select restore database

Sorry ,I thought that the correct is using attache DB instead of restore one ,is it correct?

But you need also to change the permission of the folder you download in to add the network service users full control

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-21 : 06:46:51

quote:
Originally posted by johntech

visakh16 you need to open the management studio, connect to server, right click on databases and select restore database

Sorry ,I thought that the correct is using attache DB instead of restore one ,is it correct?

But you need also to change the permission of the folder you download in to add the network service users full control

it depends on what file you have in hand
if its .bak file you need to do a restore whereas if its .mdf file you need to do attach

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

lamboguy
Starting Member

3 Posts

Posted - 2011-11-21 : 21:56:06

Thanks everybody, much appreciated!

Fred

Fred

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-22 : 00:55:45

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources