Viewing 15 posts - 466 through 480 (of 774 total)
My scenario is this:
I have this database (oltp database) where users insert data during the day.
Database don't grow more that 50 MB per month because of this.
At the end...
June 9, 2011 at 8:34 am
I don't agree with you, when you say that if I truncate the log file i can loose data.
If i do a Full Backup immediatly after doind the truncate i...
June 9, 2011 at 6:55 am
What if i leat the databases in Simple recovery model because of the bulk operation but do a diferencial backup from 10 to 10 minutos?
I can talk to them and...
June 9, 2011 at 6:53 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:
After changing my databases to full...
June 9, 2011 at 3:57 am
I think that the solution to my problems maybe truncating the trsanaction log after making a full backup of the database at the end of the day.
What do you think?
June 9, 2011 at 3:48 am
"River: As for size of backup. Maybe. Can't say for sure. "
That's another problem... Because we have to send the backup through internet to other places and the connections are...
June 9, 2011 at 3:46 am
"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.
June 9, 2011 at 3:43 am
hum.... In that case i have a problem.....
Maybe i have to swich between recovery models when doing the bulk insert (bulk verocry and then back to full again) but that...
June 9, 2011 at 3:15 am
Thank you Gail.
What about this:
"I have some bulk insert during the end of the day in this databases, i think that this was why the person that created this databases...
June 9, 2011 at 3:02 am
🙂 the problem is taht i don't know what is the better for me.
I have SQL Server 2000 and i need that a job send an e-mail every time it...
June 3, 2011 at 9:32 am
It has 4 links:
?downloads/xpsmtp/xpsmtp80-v1.1.0.8.zip
?downloads/xpsmtp/xpsmtp70-v1.1.0.8.zip
?downloads/xpsmtp/sp_smtp_sendmail.sql
?downloads/xpsmtp/xp_sendmail.sql
Which of them it's the one?
June 3, 2011 at 4:56 am
hum...
That's the link? inside that link there are several other links...
Can you give me the direct link?
Thank you
June 3, 2011 at 3:53 am
hum... i think that it is only possible if you use outlook.
I was thinking that i could use a stored procedure to send e-mails without having to install outlook on...
June 3, 2011 at 2:34 am
"If everything seems to be going well, you have obviously overlooked something"
Sorry didn't understood? what did you meant by that?
June 2, 2011 at 8:22 am
Viewing 15 posts - 466 through 480 (of 774 total)