Viewing 15 posts - 121 through 135 (of 177 total)
The last part from the maintenance plan seems to fail. the Maintenance plan does permit me to select the operator.
As a workaround for that, you could try to set...
February 11, 2009 at 11:47 am
Reproduced this same issue on my own server, searched online and found this blog article.
Following the instructions there, I could get the alerting email. 🙂
Here is the trick in that...
February 11, 2009 at 11:35 am
Are the transactional logs backed up regularly?
If not, do a transactinal log backup first (regular transactional log backup), then shrink log will work.
If the logs are not backed up, they...
February 10, 2009 at 9:42 am
You may wanna try sending DBMAIL in HTML.
Search BOL for sp_send_dbmail, and look at the Example C:Sending an HTML e-mail message.
February 9, 2009 at 12:41 pm
2009-02-06 19:00:36.22 Skipped log backup file. Secondary DB: 'Personalization',
File: '\\CHEXSQCHNRT05\d$\NRT05\File1\tran\Personalization\Personalization_20090207030030.trn'
Not sure whether this is relevant, but I noticed that the Error message was generated on 2009-02-06 19:00:36.22 ,
but...
February 9, 2009 at 12:24 pm
Yes, it did delete my txt files.
Thanks, bethrich. Appreciate it.
February 9, 2009 at 12:12 pm
Manually restore the missing log, if you still have the log files..
Otherwise, you have to restore the full backup from the Primary DB. then restart the logshipping.
If the DB...
February 6, 2009 at 3:14 pm
I found out I have to stop the mirroring 1st.
Use master
-- Stop mirroring
ALTER DATABASE [Database]
SET PARTNER off
Good to know that!
February 6, 2009 at 2:22 pm
Larry, agree with u on that.
So i tried bethrich's method: I put the scirpts in bethrich's post into a job
and job was executed successfully, but the files in...
February 6, 2009 at 1:26 pm
USE MASTER
GO
RESTORE DATABASE MYDB
WITH RECOVERY
February 6, 2009 at 12:30 pm
Why dont you create txt/csv files and put it in FTP folders (main server remote server) then import/export the files in SQL in each remote server. try to...
February 6, 2009 at 12:28 pm
I had the same issue and modified a script found online about deleting old files, now it is in my monthly cleanup job.
Execute [dbo].[usp_DeleteOldMaintenancePlanLogFiles]
'C:\Program...
February 6, 2009 at 12:05 pm
Truncate may be a good choice as it's not logged and faster, assuming there is a lot data.
As truncate will reset your Identity value to seed
After copied the data into...
February 6, 2009 at 11:42 am
stimpy2300 (2/5/2009)
2. What performance hit will the production server take if I do the hourly log shipping?
If you do hourly log-shipping, the DB on your Reporting server will not...
February 6, 2009 at 9:21 am
Just did some testing on the sysjobactivity in msdb and figured that the following scripts coudl help you.
It will ist the running jobs, their starting time and how long has...
February 6, 2009 at 7:41 am
Viewing 15 posts - 121 through 135 (of 177 total)