Backups with SQL Server Studio Express? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Backups with SQL Server Studio Express?

Author

Topic

RichardGG
Starting Member

10 Posts

Posted - 2007-09-17 : 05:48:55

Hello,

If I understand correctly I cannot do table & databse backups and restores or exports & imports as with Enterprise Manager in SQL 2000 because I have the lowest level version of the Studio Express Manager. Is that right?

Can anyone tell me what I need to do to regain that funtionality? It will be used for managing local (on my pc) and remote databases.

If it involves downloading and installing a different Studio version:

1. which one would that be?
2. is there a cost?
3. do I need to UNINSTALL my current version?
4. if so, how do I preserve my existing local databases (since there's no backup capability)

Many thanks in advance for any advice out there!

Richard

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-17 : 09:45:27

quote:
Originally posted by RichardGG

Hello,

If I understand correctly I cannot do table & databse backups and restores or exports & imports as with Enterprise Manager in SQL 2000 because I have the lowest level version of the Studio Express Manager. Is that right?

This is not my understanding, you should be able to do backups/restores with SSMSE. You may need to get a copy of the SSMSE - SQL Server Management Studio Express if you don't have that already. Please refer to this article for more information.

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx#EEDAE

Future guru in the making.

RichardGG
Starting Member

10 Posts

Posted - 2007-09-17 : 17:21:10

Well that was certainly embarassing! <g>

It looks like I can indeed do backups, but I definitely see no export or import and table level operations as in SQL 2000 Enterprise Manager.

Do I need a diffeent version of MSSMS? If so, then all my original questions still would apply.

Thanks very much for the link!

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-17 : 20:00:40

quote:
Originally posted by RichardGG

Well that was certainly embarassing! <g>

It looks like I can indeed do backups, but I definitely see no export or import and table level operations as in SQL 2000 Enterprise Manager.

Do I need a diffeent version of MSSMS? If so, then all my original questions still would apply.

Thanks very much for the link!

You need SSIS (integration services) to do that, it is not included with express. For that you need Standard edition at minimum. You can use BCP to do import/export in express as an alternative.

Future guru in the making.

RichardGG
Starting Member

10 Posts

Posted - 2007-09-18 : 04:57:20

Aha, thanks!

1.Is the standard edition a free download?
2.Do I need to UN-install my current version?
3.If I do a backup using the current version, the standand edition should be able to restore it, correct?
4.What is BCP?

Thanks for your patience in answering my questions, I realy appreciate it.

Kristen
Test

22859 Posts

Posted - 2007-09-18 : 05:56:17

1. There is a Developer Version which is very cheap (US$50-ish I think)
3. yes (You can restore SQL 2000 Backup on SQL 2005, but not the other way round)
4. Utility to Export/Import data. You could use that to export data from just a single table (or a part of a table) to a "file". (File can be delimited, but also "Native Mode" which avoids the problems with embedded delimiter characters and so on)

On you "limited" version you can use SQL to make a backup / restore:

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Automating%20Backups,Backup,RESTORE%20syntax%20/%20example,Restore

Kristen

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-18 : 06:21:35

Also see here http://msdn2.microsoft.com/sv-se/express/aa718379.aspx
which version of SQL Express to download. There are two alternatives.
And you can always download the Toolkit separately.

E 12°55'05.25"
N 56°04'39.16"

RichardGG
Starting Member

10 Posts

Posted - 2007-09-18 : 17:30:25

ok - getting closer. From the about screen, here's what I already have:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft .NET Framework 2.0.50727.832

So I AM able to do backups (sorry).

It appears what I really need to approach the functionality of SQL 2000 Enterprise Manager in a similar environment is the SQL Server 2005 Express DEVELOPER Edition.

1. Is that correct?
2. Where can I get it? For the life of me I cannot find the thing.
3. OR, do I need SQL Server 2005 Express Edition with Advanced Services?

I apologize for being so obtuse about this but I simply cannot find the information I need which compares all these version and precisely what they offer.

Thanks again,
Richard

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-18 : 19:11:54

quote:

1. Is that correct?
2. Where can I get it? For the life of me I cannot find the thing.
3. OR, do I need SQL Server 2005 Express Edition with Advanced Services?

1. Yes
2.http://www.amazon.com/Microsoft-SQL-Server-Developer-2005/dp/B000BHQ5JW
3. No

Future guru in the making.

RichardGG
Starting Member

10 Posts

Posted - 2007-09-18 : 21:06:20

Zoroaster,

Yes! Thanks very much!

Richard

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-18 : 22:34:11

There is no sql2k5 express developer edition, sql2k5 express is different from sql2k5 developer edition. And you can't use sql2k5 developer edition in production environment.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources