Viewing 15 posts - 6,526 through 6,540 (of 9,244 total)
george sibbald (9/27/2011)
try taking a log backup of the primary, then apply that to the mirror with norecovery. Then try to initiate mirroring.
also any log backups that have been carried...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2011 at 6:39 am
i dont know much about your setup, is it likely the log will fill up in 15 mins?
If you know the mirror would be down for an excessive period of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2011 at 5:28 am
database and backup sizes?
disk layouts?
file layouts?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2011 at 4:56 am
personally i would ensure the 2 are synchronised and then pause the session, reboot the mirror and then resume the session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2011 at 4:36 am
what's wrong with using these?
exec sp_helpserver
exec sp_helplinkedsrvlogin
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2011 at 4:31 am
to be able to map a user to a sql server database you need DB_AccessAdmin role in that specific database. DB_SecurityAdmin is for managing permissions and role memberships
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2011 at 4:02 am
Just because you verified the file doesn't mean something can't happen to the file on disk 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 4:50 pm
You need to understand log shipping a little better.
At the moment you are restoring the last full backup and all logs for the previous day in one go. You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 4:47 pm
backup to disk instead of sloooooooooooowwww tape
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 2:57 pm
no you are correct, although keeping the full backup and logs from the days before wouldn't hurt. Dont want to delete them then find out your last full backup is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 2:54 pm
Mike P Barron (9/26/2011)
I thought I'd used SID security,
What option did you select during installation?
Mike P Barron (9/26/2011)
it talks about being able to use both
No, you use either not both
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 2:18 pm
jared-709193 (9/26/2011)
Of course he didn't say that the log itself was a tb, just the drive 🙂Jared
exactly, a TB for log space, WOW 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 11:58 am
george sibbald (9/26/2011)
definitely get rid of one of the log files after the restore, having two is of no use at all.
I concur
If the database is in simple recovery when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 11:42 am
yes, like i say every system is different. Here's the other thing though, if you are backing up, copying and restoring every 15 mins the disconnects and the restores are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 11:38 am
yes, you are correct. If the database is in standby mode then users have to be disconnected to restore the logs.
The point is, there isn't necessarily an absolute requirement...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 11:22 am
Viewing 15 posts - 6,526 through 6,540 (of 9,244 total)