SQL Server 2008 :: Log Shipping Status Report Through Mail?

Feb 29, 2012

i'm writing below this code..

exec msdb..sp_send_dbmail
@profile_name = 'local',@recipients='chintu@www.com'
, @subject ='Log Shipping Job succeeded'
, @QUERY = 'exec sp_executesql @stmt=N'exec sp_help_log_shipping_monitor',@params=N'

I want Log shipping Status Through Mail. Last back up transaction in the day and last restoration trn file in the day...

View 9 Replies


ADVERTISEMENT

SQL Server 2008 :: Check DB Mail Status On All Servers

Apr 23, 2015

i have 70 SQL database servers and i setup DB Mail on the 70 Servers, i want to know is there a way to find the status of all the jobs which i assigned the DB Mail and if its working/failing... is there a script i can run on powershell or SQL to find out that information

View 1 Replies View Related

Log Shipping Status Report

Apr 22, 2008

I have a log shipping configuration where Server A is primary, B is secondary and C is the monitoring Server. When I run a query on both A and B I get similar results. Which means log shipping is working fine.

However when I run 'Transaction Log Shipping Status' Report on the monitor server I am unable to tell which files were recently copy and which files were last applied. or even when the last backup occurred or a copy was made. The columns are empty. I would like to find out what would cause this to heppen?

Also is there a way to find out the lsn of the databases on both primary and secondary servers.

thanks

View 3 Replies View Related

SQL Server 2008 :: Log Shipping Report Not Running After Restart?

May 13, 2015

When trying to open the log shipping status report, I get an error: user must be in the master database. The jobs appear to be running correctly.

View 0 Replies View Related

Reporting Services :: SSRS 2008 Wants To Filter The Prod Order Status Report

Jul 9, 2015

Created Prod order status report, in status, we have different status

created =0
start =4
released =3
reported as finished =5
ended =7

I have the report, in report don't want to show the Prod order for ended status, how can I add the filter for this so it can show for all the other status not ended status. when I did on filter  <7 ,  it did not work

View 4 Replies View Related

SQL Server 2008 :: In Query - All Rows With Same Status

Oct 28, 2015

I get records from a query whose status is "Marked". I need another column to be added to result set which just says "Marked" for every record. Is that possible in query?

View 6 Replies View Related

SQL Server 2008 :: Set Up Log Shipping To 2 DR Servers Instead Of One Via SSMS GUI?

Sep 15, 2015

I have to set up log shipping from Prod server "A" to 2 different DR servers ("B" and "C")...What do i have to do differently (or additional) using the GUI (ie not using Tsql Scripts) to accomplish this, in addition to the steps that are done to log ship to just one DR server?

View 0 Replies View Related

SQL Server 2008 :: Enabling TDE On Databases Which Are Used For Log Shipping

Sep 15, 2015

I have log shipping enabled on databases(primary and secondary) and works fine. I need to implement TDE on the database. I have experience on implementing TDE on databases which are not used for log-shipping.

What are the steps needed to setup TDE which are involved with log-shipping.

View 0 Replies View Related

SQL Server 2008 :: Status Suspended On Command Killed / Rollback

Mar 4, 2015

I was running a stored procedure it was suspended for about 11 hours so I decided to kill it now its in Killed/Rollback stage for 12 hours and when check the status of roll back it says "Estimated rollback completion: 0%. Estimated time remaining: 0 seconds." its using up CPUTIME 380000 and DiskIO 970000. How to do I stop this co.mpletely

View 4 Replies View Related

SQL Server 2008 :: Script To Return Replication Status As Small Int

Mar 26, 2015

I need a script that will return the replication status as small int.

View 1 Replies View Related

SQL Server 2008 :: Reminder Emails - Records Created With Status

Jun 29, 2015

We have a difficult requirement.

When records are initially created, they are given statuses of New, Pending, Closed

By default, the status is New.

If no action has been taken after 15 days since the records were created, users are sent a reminder.

I have this part working.

The problem is that as long as the status is not equal to closed, start sending reminders every 10 days.

Here is what I am working with:

SELECT [ID] , [Name], [Email],
Status
FROMmyTable
WHERE Status_Name != 'Closed' AND Status_Name IS NOT NULL and Status_Name = 'New' and Status='Pending'
AND CONVERT(Char,DateAdd(day,-15,getdate()),101) = CONVERT(Char,Date_Entered,101)

View 2 Replies View Related

SQL Server 2008 :: Setup Log Shipping From Log Shipped Database?

Mar 20, 2015

We have log shipping for databases from production to back office (BO) environments for users to run reports. In preparation for moving a back office environment to a different server, we want to setup an addition log shipping environment, let’s call it BO2, same as the BO. One of the challenges we had was the amount of time it would take to get the full backup from production to BO2 due to the size of the database. It would take days just to transfer the full backup.

Solution:Let’s just say the database being logged shipped is DB123. Instead of using the full backup of DB123 from production, we use the mdf and ldf of DB123 from current log shipped database on the BO to setup the additional log shipping on BO2.

Steps:1.Setup the directory structure for the undo file (tuf) on the BO2 server same as the BO server.

Note: The undo can be moved to different drive after the log shipping is setup.

2.Stop SQL services on the BO server.

3.Copy the undo file (tuf), mdf, and ldf files of the log shipped database, DB123, from server BO to server BO2.

Note: Keep these files as main copies because they will be used multiple times. Do NOT copy files to where you’ll put the new database files.

4.After the files are copied, start SQL services on BO.

5.On the BO2 server, create an empty database DB123 with database name, file_id, logical names, physical names exactly the same as the ones on the BO server.
Note: Make the size of mdf and ldf small so it doesn’t take long to create the database.

6.Stop SQL Services on the BO2 server.

7.Overwrite the new mdf and ldf files of the empty database DB123 with the mdf and ldf files that were copied over from BO.

8.Start SQL services on BO2.

Note: If the file_id, logical names and physical names are not matching up, the database will be in suspect mode.

9.Do a backup of DB123 with COPY_ONLY.

10.Drop DB123 on BO2 after backup is complete.

11.Use the full backup from previous step to setup log shipping of DB123 on BO2.

Note: Below was the LiteSpeed syntax that was used

exec master.dbo.xp_restore_database @database = N'DB123' ,
@filename = N'F:SQL BackupsDB123_FULL.slsfull',
@filenumber = 1,@with = N'STATS = 10',
@with = N'STANDBY = N''C: MSSQLDataROLLBACK_UNDO_DB123.trn''',
@affinity = 0,@logging = 0

12.Stop SQL services on BO2.

13.Again, overwrite the mdf, ldf and undo file (tuf) of DB123 on server BO2 with mdf, ldf, and undo file (tuf) from BO.

14.Start SQL services on BO2.

15.Replay transaction log from PRD

Note: You can change the location of the undo file by copy the current undo file to the new location and point to new location in “STANDBY” parameter. DO NOT do cut and paste of undo file but do copy and paste.

It works on Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64) . I have not tried it on SQL Server 2012 yet.

In steps that stop/start SQL services, you can bring the database offline/online.

In a way, this is doing detach/attach a log shipped database.

View 0 Replies View Related

Report Server Status 403

Feb 21, 2007

I'm trying to
get reports and report server site aveable through user certificate.

Web site is
under default web site. Under default web site is certificate server web page,
it is aveable and configured the same way and it works if I use certificate.



If I type https://FQDN/Reports
, i get error The request failed with HTTP status 403: Forbidden. But if I type
https://FQDN/reportserver i can access.

Both sites are
aveable if I use only https. But if I but if i use Require client certificate,
than I get 403 error.



In rsreportserver.config,
there is <UrlRoot>https://NETBIOSServerName/reportserver</UrlRoot>,
does not help if I use FQDN.



If I enable anonymous
access, I can not access Reports site, an I get error 403, but on Reportserver
site I get following error :



Reporting
Services Error

--------------------------------------------------------------------------------



The permissions
granted to user 'MSVEPOIUSR_WEPO-DC' are insufficient for performing this
operation. (rsAccessDenied) Get Online Help



--------------------------------------------------------------------------------

SQL Server
Reporting Services



SQL is 2005 SP1
, and OS is Windows server 2003 SP1

View 1 Replies View Related

SQL Server 2008 :: Getting Mail When A DB Is Created

Jan 6, 2011

On our SQL 2008, we'd like to receive a mail when a DB is created, and, if possible get the name of the newly created database IN the mail.

'till now get get mail I didn't find out how to get the name of the DB in the mail... should I use WMI ?

My database mail is configured and I created a WMI event alert with this query:

SELECT * FROM CREATE_DATABASE
+ Additionnal message in the options of the alert...

But I don't know how to get the name of the newly created db unfortunately.

View 9 Replies View Related

SQL Server 2008 :: Script Out Database Mail Settings?

Sep 8, 2010

Script to Reverse Engineer / Script out your EXISTING database mail settings?

I set up a profile to use gMail, and it seems logical for me to export out the settings to a script, then run the script on my laptop, other servers, etc.

There's no built in option, so I figured i'd ping the forum before i do it myself.

There are example scripts where you fill in the blanks, examples how to set up dbmail, but i did not find anything that scripts out existing settings.

View 9 Replies View Related

Database Mail - Status Sent But Email Never Received

Jan 29, 2007

From SQL Management Studion I go to Management > Database Mail and I am trying to send a test email but I never receive anything.  I checked my SMTP Mail Server Logs and I saw no entry of my test email. 
I also I checked my SQL Database Mail Logs and everything seems fine, no errors are reported.
The msdb.dbo.sysmail_allitems shows my email status as "sent".
So what am I missing? What steps would you recommend for troubleshooting my problem?
Thank you,
Ric

View 7 Replies View Related

SQL Mail: Email With Hight Importance Status?

Nov 5, 2003

Does anybody know how to send an email using xp_sendmail sp with HIGH importance setting for the message?

Thanks,
Dim

View 5 Replies View Related

SQL Server 2008 :: Database Mail - Yahoo SMTP Configuration

May 5, 2014

I'm having trouble in configuring Yahoo's SMTP for Database Mail. Here is my current settings:

Email Address: xxx@yahoo.com
Server Name: smtp.mail.yahoo.com
Port Number: 465
This server requires a secure connection (SSL) - check
Basic Authentication
Username: xxx@yahoo.com
Password: xxx

When I tried sending a test email, it didn't work. But when I changed my SMTP to use Gmail, it worked!

View 1 Replies View Related

SQL Server 2008 :: Send Mail Task On Failure Not Triggered

Mar 26, 2015

I have multiple task flows with precedence constraints and i have changed the constraint as completion to execute the package even though there is failure in one of the tasks in the package but every time the send mail success is executed instead of Send mail Failure task.

View 0 Replies View Related

SQL Server 2008 :: Migrate All DB Mail Profiles To New Server?

Oct 6, 2015

I need to migrate the all dbmail profiles(around 15) from Old server to new SQL instance.

is their any script or any way to do so that i can perform all at a time instead of doing manually.

View 0 Replies View Related

SQL Server 2008 :: Remove Rows Affected From Query In Send Mail

May 6, 2015

I need to remove "rows affected" text from results as shown below from posted Sp. I am using set nocount on but its not working as expected.

Create Procedure DailyCheckList
As
SET NOCOUNT ON
Declare @EmailSub varchar(500),@dt varchar(100),@Msg varchar(max),@M varchar(max)
set @dt= convert(varchar(20),GETDATE(),107)

[Code].....

View 1 Replies View Related

SQL Server 2008 :: Excel File Name In Send Mail Task Using SSIS

Jun 1, 2015

I have a package which is creating a excel file 'ExcelName.xls' and storing in 'E:ReportingDelivered_Reports'. Now I have to attach this report using send mail task and send it to given mail id. To achieve this I have configured the send mail task and in Expression Builder, I have selected the below expression:

"E:ReportingDelivered_ReportsExcelName_"+
((DT_WSTR,4)Year(@[System::StartTime]))+
RIGHT("0"+((DT_WSTR,2)Month(@[System::StartTime])),2)+
RIGHT("0"+((DT_WSTR,2)Day(@[System::StartTime])),2)+".xls"

I need file name should be 'ExcelName_20150601' where suffix is the current date. But I recieve file which name is 'ExcelName', which is the original file name.

View 7 Replies View Related

SQL Server 2008 :: Failed Task In Maintenance Plan Not Being Reported By Database Mail

Apr 29, 2015

I have inherited a server on which is a maintenance plan with two subplans on different schedules. In each subplan there are Execute T-SQL tasks with scripts for index rebuilds. Each task is set up with a Completion arrow to the next task and a Failure arrow to a Notify Operator Task. I was asked to add a task for index rebuilds to a specific subplan for a specific database, which is what the other tasks also do. I discovered that my task was failing but the others were fine. No notification was sent about my task failing even though the job is marked in MSDB as a failed job. I have sent a test email using the "Send Test Email..." option when right clicking Database Mail in SSMSand I receive an email so I know Database Mail works.

I set up a test job to model the index job that I can't get notifications from. I have two T-SQL tasks that just select the top row from a small table. The first task has a syntax error that I did so it would fail. I have a failure arrow to a Notify Operator Task and a Completion arrow to another T-SQL task with no syntax error which has a Success arrow to a Notify Operator task. As expected, when I execute this job I receive one failure email and one success email.

The only other troubleshooting step I know to try is to add a Notify Operator task before my failing task. That Notify Operator task will hopefully fire to tell me that the previous step was successful. I am not having problems with the other steps so I was just thinking I would try to get the subplan to send me a success email about one of the steps that has been working fine.

View 1 Replies View Related

SQL Server 2008 :: Monitor Database Growth And If Any DB Grown By 20% Send Mail Alerts

Apr 30, 2015

Is there any automated script available to - "Monitor Database Growth and if any DB is grown by 20%, sending mail alerts"? If not, what is the approach to write the T SQL script ?

View 5 Replies View Related

SQL 2005 E-mail Client Failing To Send Email Based On Job Status....

Mar 4, 2008

Kind of a newby sql question, but here goes:I have a sql 2005 database that I have a job that runs Sunday morning at 12:30 am.  I set it up using SQL Svr Mgt Studio 2005. Under  the Management directory I set up Database Mail to work with my local SMTP server. I can send a test email just fine.I then set myself up as an operator with my email address. (Under operators directory) I then went back to the properties of the job I set up, and under 'notification', chose e-mail operator (me) when Job Succeeds. The job runs, itt suceeds, but NO email!It flat out won't work. there are NO entries in teh( email) log for errors either.  Anyone? TIA  Dan  OR is it better to script these jobs using xml? I don't have time to learn a new thing right now, just need it to work!  

View 1 Replies View Related

SQL Report Server Subscription E-mail Format As MS Word

Jan 22, 2007

I am wanting to set-up a subscription to e-mail my reports in MS Word format (either .doc or .rtf) and I do not have the option on my company's report server version.

I have read that it is possible, though I don't have the option. Is this a change to report server, or maybe is our version not updated?

I can e-mail the report out in the following formats:

XML File with report data

CSV (comma delimited)

TIFF File

Acrobat (PDF) file

Web Archive (default)

Excel



Let me know if I am just expecting too much, or if there is something that needs to be updated on our report server.

Thank you,

T.J. Bernard

View 4 Replies View Related

Recovery :: Unable To Disable Log Shipping 2008 With SA Account (or Any Other Admin)

Mar 24, 2012

I recently enabled log shipping on our production database, and I had initially accepted the default of 72 hours to delete copied logs. Well, i am running out of space quick, and I need to edit it to something like 6 hours.

When I try to disable log shipping in order to recreate it, or if I try to edit the secondary server settings when I am logged in as SA, or my windows account which has the sysadmin role assigned, I get an error that says:

Only members of the sysadmin fixed server role can perform this operation. Error 21089.

I've restarted the sql service, disabled and enabled the permission on my account, but for the life of me, i cannot get this to work!

View 10 Replies View Related

Sql Server 2008 Report

Apr 18, 2008

Hi all,

How can I get this file ?
Microsoft.ReportViewer.ProcessingObjectModel.dll
Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WinForms.dll

I read many articles which say to run the ReportViewer.exe redistributable 2008. That does not install the DLL on my PC.

Anyone has a link or could email me the file ..

Thanks,
Ashok

View 4 Replies View Related

SQL Server 2008 :: Get A Report To Run Daily Between Certain Hours?

Jun 4, 2012

Trying to get a report to run daily between certain hours. I can set a start time and an "end date" in Report Manager, but as far as I can tell, I can't say run hourly every day from X to Y. am I missing something?

If this isn't doable from RS, can I just find the associated job in the Agent and change the schedule of that job?

View 9 Replies View Related

SQL Server 2008 :: SSRS Subscription For A Report

Jun 10, 2015

I'm trying to create a subscription for a report.

I have few parameters (Query based parameter) in my report.

As you can see in the attached print screen, some of the parameter I can set in the subscription and some I can not.

View 3 Replies View Related

Report Designer Preview - SQL Server 2008

Mar 17, 2008

Hi,


I have to try Report Designer Preview and i have to make a demo for a client.

I have 2 problems.

* We need Report Designer Preview to be the end-user Report Maker Tool. But, it doesn't have the Query Designer and the MDX Query Designer. In future version of MSSQL2008, is it integrated ?

* We work with MOSS 2007 and i just want to know if it's possible to deploy directy from Report Designer Preview to a Sharepoint with Reporting Services in Integrated Mode.
If it's not, is it preview to have it ? and when ?



Thanks for your help. (if you know people from Microsoft who can help me for features in future version, thanks to forward me his email).

Cédric Boulton

View 1 Replies View Related

Can Not Access Report Manager In SQL Server 2008 Feb CTP

Mar 8, 2008



Hi, I'm a beginner on SQL Server Reporting Services field. I perform a full installation of SQL Server 2008 CTP6 Developer Editon on a clean Windows Server 2008 Enterprise machine. I log on to the machine using the built-in Administrator account so there is no UAC stuff. The Enhanced Security Configuration of IE is disabled. When I want to have a look at the Report Manager by typing http://localhost/Reports, it pops up an error says "The underlying connection was closed. Could not establish trust relationship for the SSL/TLS secure channel." It makes me confused so any help or suggestion is highly appreciated.


The following is a fraction of log file from Reporting Services:
...
ReportingServicesService!resourceutilities!b5c!03/08/2008-14:25:57:: i INFO: Reporting Services starting SKU: Developer

ReportingServicesService!resourceutilities!b5c!03/08/2008-14:25:57:: i INFO: Evaluation copy: 165 days left

ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:15:: i INFO: Appdomain:3 ReportManager_0-1-128494312954554272 started.

ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:18:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/Reports.

ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:18:: i INFO: Appdomain:3 ReportManager_0-1-128494312954554272 initialized (#1).

ReportingServicesService!appdomainmanager!e10!03/08/2008-14:28:26:: e ERROR: Remote certificate error
RemoteCertificateNameMismatch encountered for url https://localhost/ReportServer/ReportService2005.asmx.

ReportingServicesService!ui!e10!03/08/2008-14:28:27:: e ERROR: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

ReportingServicesService!ui!e10!03/08/2008-14:28:27:: e ERROR: HTTP status code --> 500

-------Details--------
System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure. at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception) at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)


...

View 4 Replies View Related

Difference Between SQL Server 2005 And SQL Server 2008 SSRS(Sql Server Report)

Apr 15, 2008

Hi all,

Please tell me about difference between SQL Server 2005 and SQL Server 2008 SSRS(Sql Server report)
Why to upgrade for Sql Server 2008

Thanks,
Ashok

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved