Viewing 15 posts - 496 through 510 (of 619 total)
GilaMonster (12/5/2008)
Schadenfreude-Mei (12/5/2008)
So its only Transaction Replication that needs Full/Bulk? I didnt know that i thought it was Replication in general.
No. As I said above
Replication does not require any particular...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 5, 2008 at 8:02 am
GilaMonster (12/5/2008)
Schadenfreude-Mei (12/5/2008)
To allow replication you db must be in Full or Bulk recovery model.
Replication does not require any particular recovery model. All forms of replication (snapshot, transactional, merge) work...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 5, 2008 at 5:50 am
Ignacio A. Salom Rangel (12/4/2008)
Javier, just to be sure, Are you able to connect to Integration Services from the first node?
Which node are you connecting from? My understanding of your...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 5, 2008 at 4:08 am
I run a similar A/P cluster, running 64-bit Enterprise.
Each node has 64GB of memory. At pressent the active node is using 14GB of memory (even though it has been capped...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 5, 2008 at 3:19 am
GilaMonster (12/5/2008)
Consider transactional replication rather.Mirroring is a high-availability solution, not for reporting.
If you think you will be updating B regularly or making changes to the databases, this could...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 5, 2008 at 3:08 am
And in response to kevriley, I think you likely get in hot water for making changes to Local Security as it would effect all none admin users of that server...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 2, 2008 at 7:45 am
Dont really understand why your putting this popst in a SQL Admin forum?
What is your role, am gonna assume third line or applications support. That being the case,...
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 2, 2008 at 7:40 am
Never tried. Good luck 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 28, 2008 at 8:40 am
Easy mistake to make. The backups will alway try to restore back to their old location (same withh attaching as well).
One more thing, ensure to move any SQL2K5 or SQL2K...
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 24, 2008 at 10:12 am
Your too quick Steve, was just gonna say that. Though prob not so eliquently :s
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 24, 2008 at 9:06 am
Sakthivel Chidambaram (11/21/2008)
Try enabling below Trace Flags
DBCC TRACEON(3213, 3605, -1)
to Log any Exception message and much more detailed information about the backup process in...
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 24, 2008 at 4:36 am
Sakthivel Chidambaram (11/21/2008)
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 21, 2008 at 5:17 am
tomas.mortensen (11/21/2008)
So im gonna share my pitfalls if any .....
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 21, 2008 at 3:01 am
Yes and i get the same response. Have narrowed it down to one database now.
Any ideas? Thanks for the response.
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 21, 2008 at 2:59 am
Certainly this can be done and it not that hard. There ar e the obligitory pre-reqs and you should read MS articles on the subject:
One of the main...
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 18, 2008 at 8:38 am
Viewing 15 posts - 496 through 510 (of 619 total)