Viewing 15 posts - 1,996 through 2,010 (of 2,840 total)
Transactional replication will break your application if you do not have PK and you are going to create it. Other than that, transactional replication is the safest bet with minimum...
May 19, 2009 at 3:22 pm
I think it is because you are saying NOINIT.
NOINIT
Indicates that the backup set is appended to the specified media set, preserving existing backup sets. NOINIT is the default.
Please double...
May 19, 2009 at 2:58 pm
Did you check permissions for this particular folder? Maybe something is not right with the permission. Just a shot in the dark.
May 19, 2009 at 2:03 pm
Did you create the Tables and stored procs and all other objects for the tools in Master by mistake?
May 19, 2009 at 1:50 pm
here is an option that you can try.... But test it out please.
SET READ_COMMITTED_SNAPSHOT ON;
SET ALLOW_SNAPSHOT_ISOLATION ON;
You could use Row level version for the Subscriber. That would mean that your...
May 19, 2009 at 1:47 pm
When you are setting up the two new Subscribers just make sure that on the Snapshot Agent page, clear both “Create a snapshot immediately...” and “Schedule the Snapshot Agent to...
May 19, 2009 at 1:40 pm
pradyothana (5/19/2009)
Try to limit PF usage between 4gb as a min and 6GB as a max.Set AWE enabled.
Why do you want to limit the PF page between 4 GB and...
May 19, 2009 at 1:37 pm
I did not understand what your question was. maybe you can specify what is the issue you are facing?
May 19, 2009 at 1:10 pm
I had seen almost the same issue here when a .NET Site was trying to use Integrated security to talk to the Db and it was failing with the same...
May 19, 2009 at 1:08 pm
Altering system DB is not the safest thing to do.
But you can move TempDB to which ever drive you want with an "Alter Database tempDB ". There are examples...
May 18, 2009 at 3:05 pm
If you do not have a DR plan with Log shipping, check the mode for the database. If it is full make is simple. But I advice against it.
The...
May 18, 2009 at 1:51 pm
You could give a fixed role like db_datareader but the only issue is that they get Select permission for tables as well.
May 18, 2009 at 1:46 pm
pogla.the.grate (5/17/2009)
I can't seem to delete the last post. I had the user set up ad bulkadmin. Removed that and it solved the problems
I do not think deleting...
May 18, 2009 at 10:30 am
I was not sure about that. Now I know for sure. Thanks for the info Gail. Learning everyday..:-)
May 15, 2009 at 2:01 pm
That would not be in the transaction log, would it? Would that cause a problem with Log Shipping? I know that you cannot truncate a table that is replicated. So...
May 15, 2009 at 1:29 pm
Viewing 15 posts - 1,996 through 2,010 (of 2,840 total)