Viewing 15 posts - 6,526 through 6,540 (of 9,241 total)
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
Ninja's_RGR'us (9/26/2011)
Is that your prefference for ssrs server over replication??
why is replication yours then 😉
For most users log shipping provides excellent report offloading. I dont understand your point about the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 10:39 am
Have you thought of implementing Log Shipping?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 8:53 am
mirjawad_2k (9/26/2011)
The server is a 64bit OS and has 32Gb...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2011 at 8:46 am
Viewing 15 posts - 6,526 through 6,540 (of 9,241 total)