Replication And Recovery Models
Apr 12, 2006Hi,
If I'm using a transactional replication and the publisher's recovery model is se to FULL, can the subscribers use simple recovery model?
Thanks.
ADVERTISEMENT
Need Help About Recovery Models
Jan 10, 2007Hi all ,
this is my first post here hope i will find help.
I'm facing problems in understanding some topics .. and i searched on the net but every time i read an article i find new things and topics.
i think i need just a good way to start from the following topics.
-recovery models (full,simple,..).
-fullback and differntial back up.
waiting for your help or even links to external articles may also help.
thanks in adavance
Recovery Models In SQL7.0
Jul 6, 2001Any one knows if the recovery models in SQL7.0 same as in SQL2000, if not the same do you know them and which one is the default.
Saad
Questions About Recovery Models
Dec 5, 2007Hello Everybody , I have Some questions and I am sure that this is the best place for them to not be questions any more.
Here are My Questions:
What is the difference between full recovery model and simple recovery model?
My database has an mdf file about 400mb and a log file about 5GB.
Is this caused because of full recovery model?
What can I do in order to make my log file smaller?
Which recovery Model Do you Suggest for Use and Why?
Thank you So Very Much
I sell my mother in law.Is anybody interested?
Disaster Recovery & Replication In SS7
Mar 14, 2000We have the following situation. Box A is publisher & Box B is a DR box that is a subscriber to Box A keeping it in line with Box A. If Box A goes down Box B then becomes the 'live' box. I assume I have to do nothing to Box B to allow this to happen but if I'm wrong please let me know. My question is :- Once Box A is back online how do I get the data from Box B onto Box A so that Box A can be made the 'live' box again?
View 1 Replies View RelatedRecovery Model And Replication
Feb 18, 2005does the recovery model also change in a replication enviroment when you change a database from simple to full?
regards
Johan van der Wiel
Johan.vanderWiel@getronics.com
Recovery :: Merge Replication In AlwaysOn?
Oct 16, 2015Merge replication on AlwayOn is configured, working fine on Original Publisher.When failover to possible publisher data is not being replicated.
Replication Monitor Error:
Message: Validation failed for the publisher 'RIMDNS' with error 21879 severity 16 message 'Unable to query the redirected server 'RIMDNS' for original publisher 'UNITEDKINGDOM' and publisher database 'TD_AO11' to determine the name of the remote server; Error
2, Error message 'Error 2, Level 16, State 1, Message: Named Pipes Provider: Could not open a connection to SQL Server [2]. '. '.
[Code] ....
Recovery :: Can Run DAG Replication Between Two Clustered Instances In FCI?
Aug 27, 2015My ambition is to run ASPStateInMemory with durability on, supplementing the in-memory database with an on-disk version to give session state persistence when and if the clustered instance of SQL runs into, say a network card failure and needs to fail to a partner node. I understand that DAG's are usually run between standalone instances of SQL running on different machines. But, can I combine the DAG with the FCI? Instead of using a remote standalone SQL server, can I just another instance in the same cluster?
View 7 Replies View RelatedReplication Disaster Recovery-Next Identity Seeds
Jan 22, 2008We have implemented replication on SQL Server 2005 with 1 publisher and 1 snapshot (non-update) subscriber.
The purpose is for emergency disaster fail-over.
If the publisher (Primary) fails, then we switch the DNS so the subscriber (Secondary) becomes ‘live’ and we need it to be able to accept new records.
The problem is that the identity seeds start at 0 on the Secondary server - so no records can be input, as there are primary key violations.
We can set the increment value to -1 for all the seeds, and this works.
However there are config & replication issues with bringing up the database on the failed (Primary) server once it is restored and back online.
Does it really need to be this complicated?
Where are the ‘next identity seeds’ for all the tables in the database stored? Can they be restored on the database when fail-over occurs?
Or is there some setting in the Microsoft SQL Dba?
Recovery :: Replication With Change Data Capture
Jul 14, 2015SQL Server 2008R2: Enabling Change Data Capture on a replicated database or its tables will have any performance impact on existing transactional replication.Is it possible to use both of them con temporarily.
View 5 Replies View RelatedSQL 2012 :: Performing Point In Time Recovery With Replication?
May 6, 2015How do I recover point in time if the database is participating in transactional replication and is a publisher.
View 0 Replies View RelatedRecovery :: Server Local High Availability Using Failover Cluster And Disaster Recovery Using AlwaysOn
Aug 17, 2015We have a requirement to build SQL environment which will give us local high availability and disaster recovery to second site. We have two sites- Site A & Site B. We are planning to have two nodes at Site A and 2 nodes at Site B. All four nodes will be part of same Windows failover cluster. We will build two SQL Cluster, InstanceA will be clustered between the nodes at Site A Server and InstanceB will be clustered between the nodes at Site B, we will enable Always On Between the InstanceA and InstanceB and will be primary owner where data will be written on InstanceA and will be replicated to InstaceB. URL....Now we want we will have instanceC on the Site B and data will be writen from the application available on Site B, will be replicated to the instance on the Site A as replica.
View 6 Replies View RelatedSQL Server Admin 2014 :: Is Bulk Logged Recovery Model Support Point In Time Recovery
Dec 23, 2014is bulk logged recovery model support point in time recovery
View 9 Replies View RelatedRecovery :: Pages On A Full Recovery Model Database Corrupted
Sep 17, 2015Pages on a full recovery model database corrupted, need to ensure data loss is minimal for restore operation am thinking about restoring the latest full backup.
View 4 Replies View RelatedTransact SQL :: Change Db In Recovery To No-recovery And Restore Transaction Log?
May 5, 2015in the process of migrating a big db from server 1 to server 2, we had to roll back the change. I started with taking a full db backup and restoring it on server 2 with norecovery, and then a couple logs with norecovery, and then the last log with recovery.
Is there some way to continue this chain now, I mean to change the db to norecovery, or other way to restore logs.
I dont want to do a new full backup.
If I try to do a log restore now i get the message:
Msg 3117, Level 16, State 4, Line 1
The log or differential backup cannot be restored because no files are ready to rollforward.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
Recovery :: AG Databases Went Into Synchronizing / In Recovery After Upgrading To 2014
Sep 19, 2015We have 3 replica AG setup. 2 replicas are in sync/automatic failover, the other(DR Server, different subnet) in asynchronous/manual mode…All these replicas were on sql server 2012, Recently we upgraded DR server to 2014. Since then we have a problem, the AG databases in 2014 instance went into ‘Synchronizing/ in recovery’ state…The SQL server error log has message, the recovery couldn’t start for the database ‘XYZ’…We tried to create a new database and add it to AG , it works for fine for other two 2012 replicas, but on 2014 we see the same issue
View 3 Replies View RelatedRecovery :: AG Database In Reverting / In Recovery State
Nov 1, 2015We have an issue with a 3 node SQL 2012 Always on availability group. Normal operation is node 1 (primary replica) with node 2 and node 3 as secondary replicas.After some patching, SQL wasn't running on node 1 hence the AG flipped over to node 2. This went unnoticed for some time and the transaction log for one of the AG databases became full on node 2 and node 3. (I think this is because it couldn't commit the transactions on node 1 so couldn't truncate it's t-log?) The DB is using synchronous replication btw.So I started SQL on node 1 and flipped the AG back to node 1 (with a data loss warning but I accepted this).Now the issue is that on node 2 and 3, the DB in question is stuck in a "Reverting / In Recovery" State. I've tried various commands such as ALTER DATABASE SET ONLINE, RESTORE DATABASE WITH RECOVERY etc but these fail stating unable to obtain a lock on the DB.
The weird thing is that on node 1 the state of the DB is "synchronised".how to resolve this issue on node 2 and 3? I've left them overnight (in case they were rolling back transactions, the DB is fairly large) but nothing seems to have happened. remove the DB from the AG in node 2 and 3 and add it back in again, ie recreate the replication?
Recovery :: How To Do A Full Disaster Recovery
Sep 10, 2015If you are doing a disaster recovery of an entire SQL 2005 cluster, can you just install SQL server and restore the system database to get the configuration?
View 4 Replies View RelatedWeb Site With Database Models
Jul 20, 2005Hi.Does anyone know any web site with common database models presented andexplained.Database models like calendar, adressbook, storehouse...Thnx in advance
View 1 Replies View RelatedWhere Can I Store Datamining Models
Jan 25, 2007I am using the Excel 2007 data mining add-in, and don't have write perms on the Analysis Services server. Can I store datamining models in an alternate location?
View 1 Replies View RelatedRsItemNotFound For Report Models
Jun 6, 2007I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.
An error has occurred during report processing. (rsProcessingAborted)
The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)
If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error
If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.
The model specified must be a generated model.
(rsModelNotGenerated)
Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.
It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.
Views And Report Models
Apr 16, 2007Need a little help here. I would like to utilize the ad-hoc capabilities of Reporting Services to grant the users of one of my web apps the ability to create all sorts of crazy reports that I don't have to develop.
Basically, this web app is a flexible survey engine. My vision is to have the users select questions from a survey that they wish to generate statistics on. My application would create a view in the database that transposes the data into a tabular format. They would then get kicked over to the reporting services web client, where they can regenerate a report model, and then fire up report builder to create their crazy statiscal abomination. (Aren't users grand!)
This process sounds wonderful, but I'm not aware of any way to get the report model to regenerate and pickup any views. I can get it to pick up any new tables that are added as long as a primary key is created for them, but I want the automated dynamic data rendering that comes with a view. Hopefully, some of you out there have tried to do this already and have some ideas that may help me. Thanks!
Mining Models Accuracy
May 10, 2007Hello
I've created models with Decision Tree and Neural Network algorithms that predict continous target. But I don't know how to interpret scores that occure under scatter accuracy plot. How should I interpret scores under scatter accuracy plot?
How can I estimate occuracy of model created with Time Series? How can I compare accuracy of model created with Time Series with models created with Decision Trees and Neural Network algorithms?
Thanks in advance.
Create Database Models From XML Schema (.xsd)
Dec 19, 2006Hi .Net Guru’s,I have an urgent requirement for my project; the issue is mentioned below;Using .Net(C#/VB.Net) I need to generate/created Database objects from XML schemas.I don't have any sample xml schema file to give you. You just imagine you have a sample .xsd file and this .xsd file will be used to create database tables.Please let me know if you have any queries. Thanks,nick
View 1 Replies View RelatedKind Transaction Models In Sql Server
May 16, 2008hi help me as soon , i need know ,i get for my teacher
View 1 Replies View RelatedQuestion On Validation Of Mining Models
Jul 16, 2007Hi, guys,
Thanks for your kind attention.
Just want to make things perfectly work and make the most of our fantastic SQL Server 2005 Data Mining Engine. Can any of you here give me some super advices on the validation of the mining models. As we always see, the 3 aspects of a mining model are: Score, Population correct, and Predict Probability. So the question is: How can we combine these three aspects to best judge the mining models by being able to tell which model is the best one? And to what extent can we really trust these mining models?
These are very important before we can actually bring the models into work to convince other people who have no ideas what are going on with these models. Yes, we just want to convince them with the results of these models and make the most of them and best help them getting the most from their business operations etc.
By the way please can you explain a bit details on each of these aspects? Thanks again.
I am looking forward to hearing from you shortly and thanks bunch for your help.
With best regards,
Yours sincerely,
Can Not Upload Report Models (smdl)
May 29, 2007I am having a problem deploying or manually uploading smdl files to reporting services. I can upload anyother type of file without a problem. (dsv, ds, etc.) However, when i try to upload a smdl file, I get
"The permissions granted to user '<me>' are insufficient for performing this operation. (rsAccessDenied)"
How do I fix this?
Thank you"
Question On Association Models: MINIMUM_ITEMSET_SIZE
Jan 6, 2007I've been experimenting with the algorithm parameters for a market basket association model. The default MINIMUM_ITEMSET_SIZE is 1. This doesn't seem to make sense: what is the point of a single-member itemset? However changing the value to 2 substantially reduces the proportion of good recommendations obtained (which I'm testing via a holdout approach).
So I'm obviously misunderstanding what the parameter means. Can someone explain it please, and also explain the observation above)?
How Can We Verify The Clustering Algorithm Models?
Dec 5, 2006Hi, all here,
Since we are not able to use accuracy chart for Clustering algorithms there. So how can we verify the accuracy of clustering algorithm models here in terms of its classification and regression tasks?
Thank you very much in advance for your guidance and advices for that.
With best regards,
Yours sincerely,
How To Deploy Semantic Models Manually?
Oct 5, 2005Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.
View 9 Replies View RelatedStored Credentials When Using Report Models?
Apr 17, 2007I am have a few reports built in Report Builder and obviously using Report Models. All these report models are using a share data source. When I try enable to enable chache or creating subscription I get and error that "Credentials used not stored".
I thought well let me store the credentials for the data source used by the model used by the report on the server. I still get the same error.
I tried to create a custom data source for the report but there is not option for connection string to connect to Report Server Model. We have "Microsoft SQL SEVER", "OLE DB", "Microsoft SQL Analysis Services", "ORACLE", "ODBC", "XML", "SQP Netweaver BI" and "Hyperion Essabe"
if I understand this right to create cache or subscription I must store the credentials for each report making shared Data source concept redundant. Also I cannot create a connection string to connect to Report Server Model.
I would greatly appreciate if anyone can tell me how to enable cache or subscriptions for report that are built on report models using shared data source.
Find Models And Prices For All The Products By Maker B
Aug 9, 2013Find out the models and prices for all the products (of any type) produced by maker B.
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
select product.type,
pc.price as pcprice,
laptop.price lapprice,
pc.model as pcmod,
laptop.model as lapmod
from product
join
pc on product.model=pc.model
join
laptop on laptop.model=product.model
where maker = 'B'
the syntex runs but its not displaying any results + I know that I have some extra columns there but its for some thing else I was trying
Can We Automate The Data Mining Models Management?
Jun 12, 2006Hi, all here,
I am having a question about automating data mining models managements. As we know in many businesses, patterns vary very frequently, therefore, the mining models created will need to be created again afterwards according to new rules appearing in the data. But can we make all these process automated like automatically assessing the mining model accuracy and automatically recreate the mining models based on predifined specifications? Would please any one here give me any idea about that?
Thanks a lot for any guidance and help for that.
With best regards,