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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 7:54 am
what was the command you used to do this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 7:43 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 6:12 am
sounds to me like someone or something is possibly restoring the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 6:08 am
exec sp_changedbowner at the principal
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 5:55 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2011 at 8:14 am
amitwadhawan (7/6/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2011 at 4:12 am
This link contains details about snapshots and how they work
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 7:38 am
Adam Angelini (9/10/2008)
1. is the above scenario possible?
No!
Adam Angelini (9/10/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 2:17 am
Viewing 15 posts - 6,976 through 6,990 (of 9,244 total)