Log Shipping Report Empty
Oct 4, 2007
I have implemented log shipping on one my databases. Logs are being shipped just fine and are even being applied. Change something on primary and you will see it on the secondary.
However when I generate Transaction Log Shipping Status Report from the Primary Server, I see that Stauts is GOOD. I see primary and secondary servers names. I see when the Last backup occured. But there is no data on COPY and RESTORE. Those columns are grayed out or should I rather say colored gray with no values.
When I go onto secondary node and generate Transaction Log Shipping Status Report, columns under Restore header are popluated. But columns under BACKUP and RESTORE are grayed out.
On monitor node Transaction Log Shipping Status Report doesnt show when the last backup, or restore or copy occured. It only shows the threshold value for backup and restore.
So I have two questions:
1) why am I not seeing all the info in one place? how can I find out how far behind is secondary?
2) shouldnt Transaction Log Shipping Status Report from any node show me same information?
3) even though changes are making it to secondary once the threshold value is hit, status would not be GOOD anymore. so no matter what I do it would be out sync when it is not.
what has gone wrong here?
View 3 Replies
ADVERTISEMENT
Dec 6, 2007
Hi ,
I have a problem using Report Viewer With SQL Reporting Services 2005.
I had a really weird issue with a ReportViewer. It would show the little green Loading progress bar image €¦ but it wouldn€™t show any data, just a white background where the output should be. I knew the data was there because exporting to Excel or PDF showed the data just fine.
The problem is report toolbar is display but NO DATA is displayed and the report comes out as EMPTY .
Thanks in advance..
Can you please help me out in resolving this problem.
View 18 Replies
View Related
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
Jan 8, 2007
Hi,
I have four reports with the same three report parameters. Two of them have defaults. Last is empty and must be selected.
I created one main report and added those four reports as sub reports. I also created 3 parameters in the main report and mapped the parameters of the subreports to the main report. I also setup that the first two parameters are filled and that the last one is empty
Now if I run the main report in the IDE it gives for the last one an empty parameter which is correct.
If I publish it to the reporting server, the last parameter gets filled by the first of the drop downlist.
Why is it not empty ? And how do I clear it ?
With regards,
Constantijn Enders
View 1 Replies
View Related
Mar 21, 2007
I have SQL Server 2005 log shipping setup with primary/secondary configuration. I can confirm from the logs that log shipping is working without issue, however, reports generated from the monitor server show this message:
Violation of PRIMARY KEY constraint 'PK__#log_shipping_mo__3ABBDC91'. Cannot insert duplicate key in object 'dbo.#log_shipping_monitor'. The statement has been terminated.
There is nothing special about the configuration. Any ideas?
View 9 Replies
View Related
Oct 10, 2007
The last page of the report has a table or rectangle (tried both) which is supposed to be invisible based on a parameter. However, the page still shows up with only the header! Apparently the report knows that the next element (table or rectangle) has to be on a new page, and only too late figures out that the element is invisible.
Anybody else encountered this, or has a solution?
Thanks
View 2 Replies
View Related
Nov 23, 2007
Hi All,
I am desging my report with few text boxes , List , Matrix Tools and binding them with proper fields
if matrix having no data it is working fine
but when ever the matrix having data, then also it is working but am Getting One extra empty page
why this is happening i am not getting
plz help me some one
View 10 Replies
View Related
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
View Related
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
Dec 17, 2007
hi,
i am facing a problem in creating labels usin Report Builder.
i need to create a 4X6 label containing 4 rows.
But in Report Builder , when i try to create a table format, it only allowing one row.
How to insert another row and place data in it?
i was successfully developed labels using report server project in VS 2005.
but it's not possible in Report Builder.
please help me out.if not understand quesion well, please feel free to ask.
thanks
-Praveen.
View 2 Replies
View Related
Mar 29, 2007
Let's say I have three fields in a table like this...
Name
Tell us about cats
Tell us about dogs
Now I have two records.
Name Billy Bob
Tell us about cats I do not have any Cats
Tell us about dogs "null"
Name Joe Slick
Tell us about cats "null"
Tell us about dogs they sure chase Cats a lot.
I want my report to generate like this:
Name Billy Bob
Tell us about cats I do not have any cats
Name Joe Slick
Tell us about dogs they sure chase cats allot.
How do I omit null fields in a report including the field description? I am pretty flexible and I am willing to explore using ASP.Net, asp, html, VS2005 ? Or please tell me a program to use. I have a lot of reports to create. The data base is MS SQL 2005. The reports need to be published to the web. Can anyone suggest the best method?
View 3 Replies
View Related
Jun 28, 2007
I have developed a report in SSRS 2005. When I try to export the output to Excel, it shows an error saying:
Error occurred during local report processing.
Error occurred during rendering of the report. Stack Empty.
Do anyone have any idea what this means and how to fix it?
I can render the report in other formats (Adobe, csv etc) without any problem. My other reports, under same project and using same dataset, are working fine.
Thanks in Advance.
View 1 Replies
View Related
Aug 10, 2007
Hi
I am making a report in Visual Studio. I€™m making a matrix report. I have made a UNION of 2 tables. One of them has a field called Date and the other one does not. But to make a UNION of these 2 tables so that the results are printed in a Matrix I have to have the same fields€™ aliases at least. So what I did is that in the second table is:
SELECT €˜ €˜ AS €˜Date€™
Right?
Now, in the report the first table gives me the dates in a format:
=Format(Fields!Estimated_Close_Date.Value, "yyyy-MM-dd")
But, the second table is it doesn€™t have a date in that field when I run the report it gives me:
1900-01-01
Something I don€™t want.
So, how do I make it understand that the second tables date field is suppose to be empty?
View 8 Replies
View Related
Jul 27, 2007
I have a main report and a subreport. If the subreport doesn't have any data then I hide it, but the main report still shows the white space of where the subreport would show up if it had data. So how can I get rid of the extra white space in the main report?
Thanks,
Han
View 3 Replies
View Related
Oct 5, 2015
I need to create a data model for powerview report but I don't have data right now. The data will be loaded later after I create the report. What technique should I use??
View 2 Replies
View Related
Mar 13, 2008
The title, I think, accurately illustrates the situation in my report.
Naturally, this result is unwanted.
How do I get the avg-function to ignore empty cells in the column?
Thanks in advance,
Pluggie
View 5 Replies
View Related
Aug 14, 2015
I have two grids in two different pages. In that one grid have more number of columns compared another grid. In this case report takes width of the first grid which has more no of columns. So empty sapce in right side of the report is there for second grid. Based on the grid size reprt width should be there. How to avoid empty space in this?
View 8 Replies
View Related
Nov 5, 2007
Hi all,
I'm trying to get empty cells from an OLAP cube to display in a report designed using the Report Builder. Of the three report types, only the Table report shows the empty cells. Is there any option/setting that I need to enable to get this to work for the Matrix or Chart reports? Something like the "Show Empty Cells" option that is available in the pivot table used by BI Dev Studio?
Any help appreciated.
View 2 Replies
View Related
May 13, 2007
Hi
I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.
Can we switch database recovery model when log shipping is turned on ?
We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.
Is there any possibility of loosing data ?
Thanks
View 1 Replies
View Related
Jun 8, 2006
Hi,
I 'm sure I am missing something obvious, hopefully someone could point it out. After a failover log shipping, I want to fail back to my inital Primary server database; however, my database is marked as loading. How can I mark it as normal?
I did the failover as follow:
I did a failover log shipping from the 2 server Sv1 (Primary) and Sv2 (Secondary) by doing the following
1) Stop the primary database by using sp_change_primary_role (Sv1)
2) Change the 2nd server to primary server by running sp_change_secondary_role (Sv2)
3) Change the monitor role by running sp-change_monitor_role (Sv2)
4) Resolve the log ins - (Sv2)
5) Now I want to fail back - I copy the TRN files to Sv1 - use SQL Ent to restore the database at point in time. The task is done; however, the database is still mark as loading. I could not use sp_dboption.
I appreciate any suggestion.
Thanks in advance
View 5 Replies
View Related
Jun 16, 2006
SQL server 2005 express reporting problem.
error message:
This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service
I got this error message when I try to connect to database hosted in another PC running SQL server 2000.
Is it true that SQlL server Express can only use Local Database Engine to host the database?
View 5 Replies
View Related
Jun 21, 2002
Could somebody please guide me on how best to Implement SQL Server Log Shipping. I have gone through BOL without luck. Thanks.
View 2 Replies
View Related
Aug 1, 2000
I need to create a RO copy of a production DB owned by an outside company. We are connectd via a WAN link, but cannot use replication. They are proposing using an initial load via tape, and sending us a text file nightly with the days changes to the DB. We will then need to load that data using BCP, DTS or some other method. Does any one have any ideas on using log shipping instead of the text file. It would only be practical to get a fresh load of the entire DB once a quarter or once a month at most. It is a 40+ GB database and we are expecting 100 to 200 MB of logs per night. For business reasons, we are limited to some type of file transfer mechanism for the data transfer, and cannot really change their backup schedule which is nightly fullbackups and tlogs every 30 minutes.
View 1 Replies
View Related
Nov 28, 2000
Can anyone point out me , What does Log shipping mean ?
Is it backup of Log file ? or moving backup logs to any other destination ?
Thanks
Karthik
View 2 Replies
View Related
Mar 27, 2002
Hi all,
I am using SQL 2k EP Editions with SP2 on Win 2k Advance servers. Since more than week or so I am trying to establish log shipping between two servers. But its not working.
I am using database maintainence plan wizard to set up log shipping. Every thing works fine as far as wizard is concern, it creats plan for log shipping. But my log shipping is not working. The plan to back up log on source database is working fine. I can see the job history and the log files in the backup folder. But I have found that the job on the standby server to copy log file on network folder is failing and so the job to restore log on stand by server. I get the following message
"sqlmaint.exe failed with error state....."
Little reaserch on the standby server found that sql server is using maintainence plan to copy and restore log files, but i do not see any database maintainence plans on standby server as well as I have checked that there is no plan id in sysjobs table on either server.
I have sa rights. The account used by sql service and sql agent have admin rights and they do have rights to access the network folder for both the servers. So there is no rights problem.
I have followed all steps published in white paper for setting up log shipping on microsoft web site.
I have searched microsoft KB but it is of no use for sqlmaint.exe.
Any help is highly appreciated.
thanks in advance.
Minesh.
View 1 Replies
View Related
Sep 6, 2000
This might end up being fairly lengthy...I'm in the midst of implementing log shipping as a "warm stand-by" solution at my company. All the components appear to be in place: I'm using cmd shell to copy the backup device file to a remote server and then execute a RESTORE stored procedure on the remote server.
The copy and restore work just fine. The problem I'm having is with the transaction log dumps and restores.
We normally dump transaction logs (and then truncate) every hour. With the log shipping being implemented, we're going to want to do separate log dumps every ten or fifteen minutes, copy that dump over to the remote server, and then apply that log to the database.
Here's the question: for the log ship portion, I don't truncate the log. But after the "normal" log dump occurs, things get tossed out of whack. When you try to apply a log, I get the message "database has not been rolled forward enough....".
Has anyone encountered this type of issue and if so, how did you work around it? I'm assuming it's a simple of issue of certain options you set on your dumps and scheduling....
I'd appreciate any help....
Thanks!!!
View 3 Replies
View Related
Sep 24, 2002
Does anyone know if Log Shipping in SQL 2000 Ent also ships over database schema changes?
View 2 Replies
View Related
Oct 14, 2002
We are considering implementing log shipping. Do the sql server logs keep track of the logs that are shipped and applied through log shipping? Or is there some other way to make sure that all logs have been shipped and applied?
View 1 Replies
View Related
Jul 25, 2004
I have been successful in getting log shipping working but still have some nagging questions that I cannot find answers to.
1. I had a situation where the copy for one TranLog took much longer than the 15 minute interval I have it setup for. It seemed to get stuck on that copy. Is that how it is supposed to behave.
2. Related to the question above, weekly, I have jobs that reorganize, check integity, recalc statistics. Would these jobs create very large log files? If so, how do others deal with this?
3. Is there any documents available that discuss testing converting your secondary server/database to your primary and back again?
4. Is there a way to setup Email notification to report out-of-sync conditions?
Any other gotcha's that people have run into.
Any help would be greatly appreciated.
Thanks,
Ken Nicholson
View 2 Replies
View Related
Feb 2, 2005
Hi
While configuring log shipping, if i choose the "allow database to assume primary role" then the "ceate and initialise new database " option is selected by default..Does this happen all the time or am i missing something.What if i have already initialised the destination database.
Thanks
Madhukar Gole
View 2 Replies
View Related
Aug 18, 2006
Hi all,
I am testing my log - shipping strategy. I have tried with northwind database and it was successfully created and is operating. However in order to test I have created a new Test Table in the primary database to see whether it is working. From now on database shows that it has been loading and I cannot see any tables it is grayed and it says loading. What would be the problem? When I checked the logs it has been copying to the secondary database and it doesn't show any error in the log-shipping monitor. It seem everything is cool accept this loading part. If some one help me I really appreciate it.
Thanks
LS
:confused:
View 6 Replies
View Related
Mar 27, 2002
Hi all,
I am using SQL 2k EP Editions with SP2 on Win 2k Advance servers. Since more than week or so I am trying to establish log shipping between two servers. But its not working.
I am using database maintainence plan wizard to set up log shipping. Every thing works fine as far as wizard is concern, it creats plan for log shipping. But my log shipping is not working. The plan to back up log on source database is working fine. I can see the job history and the log files in the backup folder. But I have found that the job on the standby server to copy log file on network folder is failing and so the job to restore log on stand by server. I get the following message
"sqlmaint.exe failed with error state....."
Little reaserch on the standby server found that sql server is using maintainence plan to copy and restore log files, but i do not see any database maintainence plans on standby server as well as I have checked that there is no plan id in sysjobs table on either server.
I have sa rights. The account used by sql service and sql agent have admin rights and they do have rights to access the network folder for both the servers. So there is no rights problem.
I have followed all steps published in white paper for setting up log shipping on microsoft web site.
I have searched microsoft KB but it is of no use for sqlmaint.exe.
Any help is highly appreciated.
thanks in advance.
Minesh.
View 2 Replies
View Related
Apr 3, 2002
Hi All,
I failed to configure the Logshipping in
SQLServer2000, through database maintenance plan wizard,
at last step I got the following error.
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 50007:xp_repl_encrypt:Error executing
srv_paramsetoutput
I am running SQLServer2000 Enterprise Edition with
Servicepack2, and Windows2000AdvancedServer with
Servicepack2 on both machines and bothe machines are in
the domain, both SQLServerservices are running under
Domain account.
thanks in advance,
Rob.
View 1 Replies
View Related
