Viewing 15 posts - 6,976 through 6,990 (of 9,253 total)
Jonathan Marshall (7/8/2011)
Error messageMsg 954
The database x cannot be opened because it is acting as a mirror database
i am able to change the owner at the principal with no issues,...
July 9, 2011 at 4:01 am
shutting down the Windows OS will gracefully shut down all running processes including SQL Server.
July 9, 2011 at 3:58 am
Helical Johan (7/8/2011)
I have sql server 2008 in windows server 2008, together 32 bits. The problem is
in the memory. It´s full. I enabled the option: Use AWE to allocate...
July 9, 2011 at 3:57 am
Lowell (7/8/2011)
July 9, 2011 at 1:26 am
Best way would be using IPSec to encrypt the traffic between the nodes
July 8, 2011 at 3:32 pm
This link details permissions required for a domain user account. It's important to remember that as well as local security policy assignments the account needs ACls across various parts of...
July 8, 2011 at 3:20 pm
arvind.1611 (7/8/2011)
@perry: Then suggest a better way out..
I already have, see above and below
Perry Whittle
To replicate a complete database, I would use either log shipping or database mirroring.
arvind.1611 (7/8/2011)
July 8, 2011 at 10:01 am
Jonathan Marshall (7/8/2011)
exec sp_changedbowner 'sa'
as you're not using a USE statement, what database focus did you have set for the query window?
also did the user account exist on the mirror...
July 8, 2011 at 7:54 am
Elizabeth.Block (7/7/2011)
finally got it to work by detaching it from the source server, ftping it, then renaming it and attaching it on the target server.
no need to detach the source...
July 8, 2011 at 6:12 am
sounds to me like someone or something is possibly restoring the database
July 8, 2011 at 6:08 am
arvind.1611 (7/7/2011)
I am planning to use transactional replication, to keep the cluster and the standalone boxes in sync,
That's probably the worse way to do this. What if any of the...
July 8, 2011 at 5:53 am
amitwadhawan (7/7/2011)
@SSCrazy, So you are saying we dont need to restore fullbackups again on secondry server ,even if we are backing our primary databases everynight?
dude amitwadhawan
please read up...
July 7, 2011 at 9:33 am
amitwadhawan (7/7/2011)
we need to restore full backup on secondry server
The first time you initialise log shipping, yes
July 7, 2011 at 8:14 am
Viewing 15 posts - 6,976 through 6,990 (of 9,253 total)