sql server new users: Managing SQL 2005 that comes with SBS -- sql server new users

You're in the

sql server new users

group:

Managing SQL 2005 that comes with SBS

Re: Managing SQL 2005 that comes with SBS

Anthony Thomas
2/16/2007 12:00:00 AM

sql server new users:

Standard Edition installs SQL Server 2005 Express Edition. You use
Management Studio Express to manage these installations:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

Premium Edition install SQL Server 2005 Workgroup Edition. You can install
the client tools from the media. Just launch the SQL Server setup off of
the disk again and add the client tools.

Anthony Thomas

--

[quoted text, click to view]

Re: Managing SQL 2005 that comes with SBS

Bob Simms
2/16/2007 12:00:00 AM

[quoted text, click to view]

The rough equivelent of Enterprise Manager is SQL 2005 Management Studio

Managing SQL 2005 that comes with SBS

Joe
2/16/2007 7:09:12 AM

What tools can I use to manage SQL 2005 that comes with SBS 2003.

I need to run scheduled management tasks to backup the sql database but I
appear to have not loaded the correct if any tools to do this.

With SQL 2000 you had enterprise manager to do.

Thanks,

Joe

Re: Managing SQL 2005 that comes with SBS

Anthony Thomas
2/19/2007 5:27:13 PM

Yes, it was "different" using SQL Server 2000 Enterprise Manager; however,
MSDE 2000 did not come with SQL EM. You had to code everything or use OSQL.
So, it is not quite the same comparison.

According to this, however, SSMSE does NOT come with the Maintenance Plan
Wizard, just like MSDE, because it does not install the SQL Agent job
scheduler.

http://download.microsoft.com/download/E/8/B/E8B42814-6A0C-40EB-911F-E7ADEC87F5D5/UpgrExptoWkgStd.doc

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

http://msdn2.microsoft.com/en-us/library/ms365247.aspx

I guess you will have to code tasks through SQLCMD and the Windows Scheduler
or a scripting language.

Anthony Thomas

--

[quoted text, click to view]

Re: Managing SQL 2005 that comes with SBS

Joe
2/19/2007 7:19:50 PM

I've tried both and don't know enough about SQL management to know how to
use the Management Studio to do what appears to have been easier in SQL 2000
using Enterprise manager.

Joe

[quoted text, click to view]

Re: Managing SQL 2005 that comes with SBS

Bob Simms
2/19/2007 11:18:54 PM

[quoted text, click to view]

Open Management Studio. Expand Management. Right click Maintenance Plans
and click Maintenance Plan Wizard. On the 3rd screen choose Backup Database
and fill in the corresponding dialog boxes as to which db and when.

--

Bob Simms
www.xpertise.co.uk

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn