Can MSDE Do Log Shipping?

The subject line pretty much says it all. I'be been trying to use the SQL
Enterprise Administrator that came with SQL 2000 Enterprise to configure log
shipping, but the checkbox does not appear for databases on my MSDE servers,
only for the databases on my SQL 2000 Standard servers. Is there a way to set
up log shipping with MSDE?
--EricYes and no.
Log shipping is built in to Enterprise Edition only. However, there is
nothing preventing you from writing your own or using a third-party Log
Shipping solution with MSDE. The SQL 2000 Resource Kit even has an example.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message
news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the SQL
> Enterprise Administrator that came with SQL 2000 Enterprise to configure
log
> shipping, but the checkbox does not appear for databases on my MSDE
servers,
> only for the databases on my SQL 2000 Standard servers. Is there a way to
set
> up log shipping with MSDE?
> --Eric|||To expand on Geoff's post, here is a site that you may find helpful:
http://sqlguy.home.comcast.net/logship.htm
-- Keith
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message =news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the =SQL > Enterprise Administrator that came with SQL 2000 Enterprise to =configure log > shipping, but the checkbox does not appear for databases on my MSDE =servers, > only for the databases on my SQL 2000 Standard servers. Is there a way =to set > up log shipping with MSDE?
> > --Eric

can I use MS Access reports on SQL Server 2000 db?

Hi,
I have a SQL Server 2000 db on which I would like to perform querys and have
pretty reports printed. Can I use MS Access (for the pretty reports) to
connect to the SQL Server 2000 db? If yes, can you please tell me how to
set up the connection?
Thanks,
Rogue Petunia"Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> Hi,
> I have a SQL Server 2000 db on which I would like to perform querys and
have
> pretty reports printed. Can I use MS Access (for the pretty reports) to
> connect to the SQL Server 2000 db? If yes, can you please tell me how to
> set up the connection?
--
Hi Rogue,
You can use the Access ADP to link data from SQL Server. The Access ADP uses
OLE-DB to connect to SQL Server.
For more details, please consult your Access doco's.
Hope this helps,
-Eric Cárdenas
SQL Server support|||Hi Eric,
Totally lost. Don't know what ADP is. Looked in Access Help, can't find
ADP.
Further details appreciated.
Thanks.
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:3fce4bf3$1@.news.microsoft.com...
> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> > Hi,
> > I have a SQL Server 2000 db on which I would like to perform querys and
> have
> > pretty reports printed. Can I use MS Access (for the pretty reports) to
> > connect to the SQL Server 2000 db? If yes, can you please tell me how
to
> > set up the connection?
> --
> Hi Rogue,
> You can use the Access ADP to link data from SQL Server. The Access ADP
uses
> OLE-DB to connect to SQL Server.
> For more details, please consult your Access doco's.
> Hope this helps,
> -Eric Cárdenas
> SQL Server support
>|||"Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> Hi Eric,
> Totally lost. Don't know what ADP is. Looked in Access Help, can't find
> ADP.
--
Hi Rogue,
ADP stands for "Access database project." The other Access file is MDB for
"Microsoft database." IIRC, the ADP was introduced in Access 2000.
The difference in the ADP and the MDB is that the ADP contains no data. The
ADP is purposely designed to use SQL Server (or any OLE-DB source). The MDB
can store data using Access tables. The MDB uses ODBC to connect to SQL
Server.
What version of MS Access will you use?
Let me know if you need more information.
--
Eric Cárdenas
SQL Server support|||Eric,
A co-worker just showed me how to do it. Sort of like a variation of "a
picture is worth a thousand words" ;) Now it totally makes sense.
thanks anyway,
Rogue Petunia
"Eric Cardenas - ANZ MSFT support" <anonymous@.discussions.microsoft.com>
wrote in message news:3fce5657$1@.news.microsoft.com...
> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> > Hi Eric,
> > Totally lost. Don't know what ADP is. Looked in Access Help, can't
find
> > ADP.
> --
> Hi Rogue,
> ADP stands for "Access database project." The other Access file is MDB for
> "Microsoft database." IIRC, the ADP was introduced in Access 2000.
> The difference in the ADP and the MDB is that the ADP contains no data.
The
> ADP is purposely designed to use SQL Server (or any OLE-DB source). The
MDB
> can store data using Access tables. The MDB uses ODBC to connect to SQL
> Server.
> What version of MS Access will you use?
> Let me know if you need more information.
> --
> Eric Cárdenas
> SQL Server support
>|||You can also use an MDB. Base your reports on a pass-through query or
a query against a linked table/view.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Wed, 3 Dec 2003 16:55:28 -0500, "Rogue Petunia"
<roguepetunia@.NOSPAMnyc.rr.com> wrote:
>Eric,
>A co-worker just showed me how to do it. Sort of like a variation of "a
>picture is worth a thousand words" ;) Now it totally makes sense.
>thanks anyway,
>Rogue Petunia
>
>"Eric Cardenas - ANZ MSFT support" <anonymous@.discussions.microsoft.com>
>wrote in message news:3fce5657$1@.news.microsoft.com...
>> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
>> > Hi Eric,
>> > Totally lost. Don't know what ADP is. Looked in Access Help, can't
>find
>> > ADP.
>> --
>> Hi Rogue,
>> ADP stands for "Access database project." The other Access file is MDB for
>> "Microsoft database." IIRC, the ADP was introduced in Access 2000.
>> The difference in the ADP and the MDB is that the ADP contains no data.
>The
>> ADP is purposely designed to use SQL Server (or any OLE-DB source). The
>MDB
>> can store data using Access tables. The MDB uses ODBC to connect to SQL
>> Server.
>> What version of MS Access will you use?
>> Let me know if you need more information.
>> --
>> Eric Cárdenas
>> SQL Server support
>>
>