Viewing 15 posts - 316 through 330 (of 860 total)
winston Smith (6/30/2011)
But this is where i get confused. How do i know what log Exactly to start with?
Do i use the first log backup taken after the diff finished?
Do...
July 1, 2011 at 12:07 am
Akkare (6/30/2011)
Can somebody explain why Mirroring not possible in Bulk recovery model
The reason is DB mirroring required all the modification to send to the mirror partner that is fully logged...
July 1, 2011 at 12:02 am
Coolroof (6/30/2011)
SELECT * FROM msdb.dbo.sysmail_event_log
msg is
"The mail could not be sent to the recipients because of the mail server failure....
June 30, 2011 at 11:48 pm
kamleshsinhchauhan (6/30/2011)
I tried many possible way ... but its taking time and...
June 30, 2011 at 11:31 pm
Coolroof (6/30/2011)
job alert..when job is completed after that automaically send to mail..
Do you have DB mail setup, Then use the notification and select the email option use whatever option you...
June 30, 2011 at 11:25 pm
natarajan.p (6/30/2011)
How to all jobs move from sql server 2000 to sql server 2008..?
take a script using gui in 2000 and run it to 2008.
June 30, 2011 at 2:47 am
subbkarth (6/30/2011)
I got a mail automatically when ever the space issue occurs
Check the script may be its written worngly. Or show me ll tel you.
what its return xp_fixeddrives.
June 30, 2011 at 2:43 am
manning20 (6/29/2011)
June 30, 2011 at 2:37 am
manning20 (6/29/2011)
June 30, 2011 at 2:31 am
sql_novice_2007 (6/29/2011)
If the recovery model is simple the transactional log file will be shrinked with each db backup,right?
Following post will clear your doubts.
http://sqlserverblogforum.blogspot.com/2011/03/difference-between-truncating-and.html
June 30, 2011 at 2:24 am
sql_novice_2007 (6/29/2011)
June 30, 2011 at 2:23 am
horaciovel (6/29/2011)
June 30, 2011 at 1:25 am
First don't use the GUI instead of use server side trace http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
As i told use the server side trace and collect the data in any one of your drive and...
June 30, 2011 at 1:10 am
ashok.faridabad1984 (6/29/2011)
Please help help..
Tempdb size does not reduce even though there is not temp table in the database and unallocated space is showing 800% of the used space, Please help...
June 30, 2011 at 1:00 am
a_shakeel (6/30/2011)
Try to shrink the data files. If this also does not work, restart SQL Server.
Nope don't shrink. Shrinking the tempdb is not good advise sometimes it'll do different things.
Change...
June 30, 2011 at 12:55 am
Viewing 15 posts - 316 through 330 (of 860 total)