Im getting this error when trying to sync transaction on offline database to primary server.
some one cant help me to solve this issues, we need to do maintenance to the primary server and 1 day the online server need to be shutdown. But the offline server was getting that error. I check the database on Store Operations Administrator and not getting error about integrity of the tables.
*This post is locked for comments
Thank you Jeff! This was perfect and solved my issue perfectly!
There isn't one in 2k8; run this instead;
-- Turn on advanced options
EXECUTE SP_CONFIGURE 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
-- Set max server memory = 6400MB for an 8g Server machine -- 1/2 for 4g
EXEC sp_configure'max server memory (MB)',6400;
RECONFIGURE WITH OVERRIDE
-- Turn on Ad Hoc Queries
EXECUTE SP_CONFIGURE 'Ad Hoc Distributed Queries', '1'
RECONFIGURE WITH OVERRIDE
-- Turn off advanced options
EXECUTE SP_CONFIGURE 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
-- Change Recovery Mode to Simple to prevent log file growth
ALTER DATABASE "databasename" SET RECOVERY SIMPLE
-- Turn off AutoClose in Express versions
EXEC sp_dboption 'databasename', 'autoclose', 'FALSE'
You need modify the line ending in 6400 depending on the amount of RAM you have, its set for 8g, change to 3200 for 4g,1600 for 2g
Then modify the last two sections containing the databasename and change to your our database name.
I have a same problem, but i am using sql server 2008 r2.
where is the " Enable OPENROWSET AND OPENDATASOURCE SUPPORT" option for sql 2008 r2?
I have enabled this option and it works fine. My primary and offline databases are being synchronized when I execute z report on POS.
Follow these steps to enable
Start-> Microsoft SQL server 2005 -> Configurations Tools -> SQL Server Surface Area Configurations
Then Click
Surface area Configuration for features
Then select check box with the option of “Enable OPENROWSET and OPENDATASOURCE support”
Are you using SQL 2005 Express Edtion if yes please enable Adhoc Remote queries in surface are configartion.
Solve
Easy a Reindex work for me. jejeje
Store Operations Manager > Database >Reindex
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (