Sunday, February 12, 2012

Backing up WMSDE

I am trying to backup WMSDE from Sequel Server tools and keep receiving the
following error. "sequel server does not exist or access denied". I also
noticed that when i log onto the server and the system tray application does
not even recognize the services on the server, but sharepoint works
completely fine. Any ideas?
Bill
hi Bill,
Bill wrote:
> I am trying to backup WMSDE from Sequel Server tools and keep
> receiving the following error. "sequel server does not exist or
> access denied". I also noticed that when i log onto the server and
> the system tray application does not even recognize the services on
> the server, but sharepoint works completely fine. Any ideas?
> Bill
WMSDE should be managed via SharePoint only, as it is a dedicated version of
MSDE modified for it's uses only...
as regard the exception you get, this is a general MDAC error that can be
troubleshooted via
http://support.microsoft.com/default...06&Product=sql
hints..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||So you are suggesting that Sequel tools should not be used to manage wmsde?
How else can you back the database up? I believe the help file suggests
using sequel tools.
"Andrea Montanari" wrote:

> hi Bill,
> Bill wrote:
> WMSDE should be managed via SharePoint only, as it is a dedicated version of
> MSDE modified for it's uses only...
> as regard the exception you get, this is a general MDAC error that can be
> troubleshooted via
> http://support.microsoft.com/default...06&Product=sql
> hints..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Bill,
Bill Ervin wrote:
> So you are suggesting that Sequel tools should not be used to manage
> wmsde? How else can you back the database up? I believe the help
> file suggests using sequel tools.
no, I'm not suggesting you have not to use SQL Server Client Tools, but you
have to be carefull... AFAIK, as
http://www.microsoft.com/resources/d...s/stsglos.mspx
states, you must be running SQL Server 2000 and not WMSDE to back up and
restore the entire configuration database and each content database on your
server..
but I'm not a SharePoint guy
perhaps you'll find better support on SharePoint newsgroup hierarchy..
I apologise..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment