Viewing 15 posts - 6,976 through 6,990 (of 9,241 total)
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
The following will set the max server memory to the value you specify in MB's
exec sp_configure 'show advanced options', '1'
reconfigure
exec sp_configure 'max server memory (MB)', 'set this'
reconfigure
exec sp_configure 'show advanced...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 2:15 am
arvind.1611 (7/5/2011)
The Stand-Alone SQL Server currently has 7 databases, with total database size of ~500GB. The Transaction log growth per day is around 25 GB.
thats the max size the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 2:06 am
Ol'SureHand (7/5/2011)
be careful before doing a full backup as this will break the transaction log backup chain.
No it doesn't, changing the recovery model from Full or Bulk Logged to Simple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2011 at 1:57 am
Viewing 15 posts - 6,976 through 6,990 (of 9,241 total)