Viewing 15 posts - 6,541 through 6,555 (of 9,253 total)
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...
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
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 😉
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...
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...
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...
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...
September 26, 2011 at 10:39 am
mirjawad_2k (9/26/2011)
The server is a 64bit OS and has 32Gb...
September 26, 2011 at 8:46 am
p.van.der.zande (9/26/2011)
how to solve it?
Put the DVD disc into the drive, run the setup and upgrade the existing instance. Ensure you have backups first.
September 26, 2011 at 8:36 am
Dan-Ketil Jakobsen (9/26/2011)
and 1 TB for log.
wow!
September 26, 2011 at 8:28 am
isuckatsql (9/26/2011)
What type of performance improvement could i expect from a two node cluster, running sql server 2008 r2 x64 enterprise, over just a single server.
As Gail said, absolutely none....
September 26, 2011 at 8:26 am
Is this a Windows cluster or a Veritas Cluster Server?
Are you saying that you saved the SP executable to the C drive and ran it from there?
September 26, 2011 at 8:00 am
can you post the table definition
September 26, 2011 at 7:13 am
Dr Pliers (9/26/2011)
How do I change the AD Group that I specified as part of the cluster security policy?
so you used legacy group security and not Service SID based security?
September 26, 2011 at 7:08 am
Viewing 15 posts - 6,541 through 6,555 (of 9,253 total)