Viewing 15 posts - 376 through 390 (of 860 total)
GilaMonster (6/9/2011)
What do you gain by that? Other than ensuring that if the full backup is damaged you have NO recovery path.
Exactly we...
June 9, 2011 at 11:13 am
muthukkumaran Kaliyamoorthy (6/8/2011)
forsqlserver (6/8/2011)
u can Check itCan you give me the reference.Where you got it.
I have tested its working.
June 9, 2011 at 11:11 am
Kahn
Gail already given the log file management.
Also,read the post which will help you to understand the backups and models advantage and disadvantage.
June 9, 2011 at 4:09 am
If i truncate the log file AFTER doing a full backup , how can i lose data?
The full backup as all the data.
It's like this:
You can't perform the log backup...
June 9, 2011 at 4:04 am
GilaMonster (6/9/2011)
muthukkumaran Kaliyamoorthy (6/9/2011)
In bulk logged PTR is not possible.
Not true.
agreed gail. I missed that.
The drawback is point in time (PTR) recovery is not possible, when there is a bulk...
June 9, 2011 at 3:59 am
river1 (6/9/2011)
What do you...
June 9, 2011 at 3:52 am
river1 (6/9/2011)
"In bulk logged PTR is not possible"What is PTR?
No data can be lost, that's why i need do change the recovery model to full.
Point in time recovery.
Ok then do...
June 9, 2011 at 3:49 am
What i ask is :
In simple recovery model, log don't grow so much and when i make a backup the total size of the file backup is small.
In simlpe recovery...
June 9, 2011 at 3:34 am
Nope the log file will grow in simple recovery model if the log file have open transaction.
June 9, 2011 at 3:26 am
river1 (6/9/2011)
P.S ,
I have some bulk insert during the end of the day in this databases, i think that this was why the person that creted...
June 9, 2011 at 3:22 am
forsqlserver (6/8/2011)
u can Check it
Can you give me the reference.Where you got it.
June 8, 2011 at 6:37 am
Yes, but you must log ship to a different database name
Is this correct?
I think Logshipping needs two instances.
June 8, 2011 at 5:14 am
This post not covers full SQL architecture, But its help.
June 8, 2011 at 4:47 am
forsqlserver (6/7/2011)
Dear Muthu,Thanks but DBCC shrink is deprecated.
Pls Can you prove me.
June 7, 2011 at 6:32 am
Viewing 15 posts - 376 through 390 (of 860 total)