Viewing 15 posts - 226 through 240 (of 860 total)
san (4/9/2009)
how to take transaction log backup without .mdf file
Interesting, What are you trying to do here?
April 9, 2009 at 8:49 pm
Anything in the application/error log please?
April 9, 2009 at 8:45 pm
Hi Amu,
Amu (4/9/2009)
. Over the 10 years of time, the database grown to 500GB and set auto growth by 200MB.
Is this the right setting. What is the rate of...
April 9, 2009 at 6:19 pm
Edd (4/8/2009)
The SQL log and Event Viewer indicate the maintenace plan is still looking for an old missing TRN file.
(Operating system error = 3. The system cannot find the...
April 9, 2009 at 4:53 pm
kotlas7 (4/9/2009)
thank you,My Question is if choose the delay restoring backup atleast as 30 mins, do we need to change Restore schedule to run every 30 mins?
Test and see what...
April 9, 2009 at 4:18 pm
Tara Kizer (4/9/2009)
Yes that is true, but the OP is mentioning transaction log backups every 15 minutes so that's why we are focusing on that strategy.
Alright, true. Thanks for the...
April 9, 2009 at 3:22 pm
Tara Kizer (4/9/2009)
Krishna Potlakayala (4/7/2009)
Michael Valentine Jones (4/7/2009)
Since I have a full backup every day, I usually do not do a differential backup.
Incorporating differential backups into...
April 9, 2009 at 3:10 pm
Hi Iqtedar,
If your database is in Simple recovery model it doesn't mean that log should not grow it only means that the tlog will not fully record the transactions that...
April 9, 2009 at 9:22 am
sudhirrsingh.parmar (4/9/2009)
I also have 5 day old full backup of my database.
And also how come you don't have a recent backup ? What are your business requirements?
April 9, 2009 at 7:03 am
Hi,
No its not possible to rebuild a .mdf file using .ldf file. If your log file(.ldf) is corrupt then you can rebuild the log which is the last course...
April 9, 2009 at 6:39 am
No, that't not possible if you are asking you can cache a single database. Query optimizer will chose the frequently access objects. More the memory the more objects it can...
April 9, 2009 at 6:26 am
Hi,
I don't think security will cause any performance hit on the sql server. Is ther anything on SQL logs. Can you give us more insight into as whats happening against...
April 9, 2009 at 6:19 am
Is there any use to use Witness and mirror on the same instance?
April 9, 2009 at 2:50 am
In that case you could think of Pull subscription where the subscriber pulls the data from the publisher whenever the network is connected.
April 9, 2009 at 2:48 am
kotlas7 (4/8/2009)
So No need to take the regular Transaction log backups using the backup job for the databases involved in Logshipping right?
Hi,
what jhon advised is true.
My two cents:
No just log...
April 9, 2009 at 2:46 am
Viewing 15 posts - 226 through 240 (of 860 total)