Viewing 15 posts - 6,976 through 6,990 (of 9,244 total)
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
amitwadhawan (7/6/2011)
July 7, 2011 at 4:12 am
This link contains details about snapshots and how they work
July 6, 2011 at 8:35 am
yes, also bear in mind to have a read only mirrored database you need to use snapshots which you may or may not be comfortable with
July 6, 2011 at 7:47 am
you can extend the mirroring timeout and thats about it. Log shipping is better if you want a scheduled movement of the data and you can have it read only...
July 6, 2011 at 7:38 am
Adam Angelini (9/10/2008)
1. is the above scenario possible?
No!
Adam Angelini (9/10/2008)
July 6, 2011 at 6:09 am
you can also delete the current backup before taking the new but this is not recommended for obvious reasons
July 6, 2011 at 2:17 am
Viewing 15 posts - 6,976 through 6,990 (of 9,244 total)