slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Synchronization
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Synchronization | New Thread

View: Search:

Author

Thread: Quick question on cutting a remote office database

Jeff Weight
Posts: 219

Quick question on cutting a remote office database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Dec 07 1:00 PM

With SalesLogix version 7.2, can I cut a remote office database directly on SQL Server 2005 now, or do I still need to use a separate SQL Server 2000 instance?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Quick question on cutting a remote office database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Dec 07 12:12 PM

Yes.. as long as the remote office db is:
A - sqlexpress (remember keep it to 10 users or less or you will have performance issues
or
B - SQL2005

Because the cut will NOT be compatable w/sql2000/MSDE and you will NOT be able to attache it.

Oh yes. Install MSDE on the Workstation.. cut there and it's.. yes.. sql2000/msde comatable!
--
rjl

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Quick question on cutting a remote office database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Dec 07 4:31 PM

Thanks RJL!

The remote office database server is SQL Server 2005, so I guess I am safe. I can't use MSDE anyway, because I have heard a few times that you can only create databases that are 2 gigs or less with it when cutting remotes, and my remote databases are 8-9 gigs in size. But since my remote office db server is 2005 - I get to ignore all that

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Quick question on cutting a remote office database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Dec 07 5:59 AM

Correct, this is a Microsoft [deliberate] limitation - for MSDE it was 2Gb and with SQL Express is now 4Gb - so, still wouldn't cut it

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/12/2025 4:42:52 PM