Data Recovery??
May 14, 2001
Hi,
I have SQL 7.0, SP2 running on NT 4.0 with SP5. I have a central publisher and
numerous subscribers using nightly merge push replication. There seems to be some
problem with the rollback after a failed attempt at replication. The publisher
states that there was no response from the sub database and that it was suspect.
From the sql logs on the sub, I can see that the db went into recovery mode,
recovered 100%, howerver all the data in the subscribing database has disappered.
The schema of all the tables is intact and the database still reads at its old
size ~2Gigs. I can't see the data though. The publisher or other subscribers have
suffered no similar loss of data. It seems that there was some sort of error when
the database was trying to rollback to where it was before the attempted
replication. Has anyone experienced anythng similar? Anyone know how I can
recover the data?
I ran a dbcc checkdb, but it reported no errors, saying that there were no rows
in any of my replicated tables.
Any help / suggestions are appreciated.
JC
.
View 2 Replies
ADVERTISEMENT
Dec 5, 2002
Hi All!
I made a big mess recently and i need an urgent help. We have 12 months of our company data located in 2 sql servers out of which one server contains 9 months of data (Say A)and another contains 3 months of data (Say B).
The server which contains 9 months data was taken a backup in June 1st week and this is the last backup to the databae in this server.
Now i have tried to append the 3 months data to the 9 months data. So i selected the export option of the B and overlooked the option of "Delete destination objects first".
This creared the disaster. It deleted all our 9 months data in A and wrote down the 3 months data in B.
Now i need to receover the 9 months data in A which was deleted.
Any help please.
I tried with Logexplorer evaluation version but it permitted me to only Northwind and Pubs database.
And also i have tried some other tools like MS SQL Recovery but as evaluation products they didnt helped me completely.
Please let me know if you have any other ideas.
Iam in complete risk, now. :(
Regards,
Satish.
View 4 Replies
View Related
Apr 13, 2002
hi,
we are working on SQL server the tables got accitental deleted .we also dont have a back up of the database If anyone can please help me out with how to get back the data
View 1 Replies
View Related
Jun 30, 1999
Hi there,
IS it possible to recover the database from .Dat files? If we only have the Device files of the old database. Can we import it(Atleast the data in the tables) into the new server?
Thanks in advance
View 1 Replies
View Related
Dec 1, 2006
To the point....My company received a disc containing our last year's databaseinformation from the online company that we use for our documentation(They use SQL ). Only thing is, we are a small business and do not havea "server", therefore we do not have sql server, therefore we can't getour documentation off of the disc. The thing is, we're beingaccredited next week and I need this information for accreditationpurposes. I need to know if there is another option to retrieve thisinformation without purchasing Microsoft Server and SQL Server.any advice / help would be much appreciated.CRS
View 6 Replies
View Related
Aug 17, 2015
We 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 Related
Dec 23, 2014
is bulk logged recovery model support point in time recovery
View 9 Replies
View Related
Sep 17, 2015
Pages 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 Related
Jul 25, 2000
I am a newcomer for SQL Server. Yesterday my NT was down, and had to be reinstalled. Therefore SQL Server 7 used has to been reinstalled too. Though old data files for SQL Server still exists, however, reinstalled SQL Server 7 cannot use them directly. I just wonder if there are any method or utility that are able to recover those previous data? Thanks very much in advance.
View 1 Replies
View Related
Dec 19, 2007
Hi
DepartmentMaster table has been deleted
how can I retrive the data from transaction log?
thanks
View 5 Replies
View Related
Dec 19, 2007
I have a client with a badly corrupted SQL database including things like errors in pages where sysindexes resides among many others. They do not have a good backup. I have had First Advantage Data Recovery Services (www.datarecovery.net) evaluate the database and quote to repair (over $7500).
Does anyone have any experience or reccomendations they can share about this or other companies that provide data recovery services for SQL databases?
View 5 Replies
View Related
May 5, 2015
in 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.
View 6 Replies
View Related
Sep 19, 2015
We 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 Related
Nov 3, 2006
Hi
I am trying to recover a set of tables with data that was dropped. This data was not backed up. Please advice, is there any way this data can be recovered.
View 1 Replies
View Related
Apr 1, 2008
Hello,
Any body helop me in such respect that my log file was corrupt. I have mdf file only. Is there any tool to recover data from mdf file or export data to any other db.
thanks
Mansoor .net developer
View 4 Replies
View Related
Jul 14, 2015
SQL 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 Related
Sep 23, 2015
My client has on a physical server (A), the following:
1. MS SQL Server 2008R2
2. MS SQL Server (Reporting Server)
The data base is backed up fully daily to another physical server (B).
What the client would like to do is:
1. Backup just the Raw SQL Data with Tables and Views to Server B every 10 mins
Point to be noted is, there isn't any dedicated storage (NAS or SAN) just local disk storage on the server.
The reason for this is they want to run reports against this data every 10-15 mins...
How and what do I need to do to facilitate this?
View 15 Replies
View Related
Feb 13, 2007
Hello there
I have a SSIS 2005 DTSX Package which has several Data flow tasks which directly dump data between tables from 2 different databases.
Suppose if my destination database is named, DestinationDB, what recovery model should I select for this database so that my ldf file size does not explode? I want to keep the ldf file as small in size as possible.
Currently I have used Simple Recovery model, and the ldf file size goes to around 80 GB. (Inserting around 200 million rows)
Will Bulk Logged model be a better option?
Also what does a SSIS 2005 Data flow task use internally? (Insert operation or some sort of Bulk Insert between DBs)
Please help.
View 3 Replies
View Related
Nov 1, 2015
We 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?
View 2 Replies
View Related
Sep 15, 2015
I have two production servers in the same data center. I need to ensure that database remains available if a catastrophic server failure or a disk failure occurs. I need to maintain transactional consistency of the data across both servers. I need to achieve these goals without manual intervention. I was suggested to use this optionTwo servers configured on the same subnet. SQL Server Availability Group configured in Synchronous-Commit Availability Mode<<<<But I think the correct answer should be Two servers configured in Windows Failover Cluster in the same data center SQL Server configured as a clustered instance<<<<
View 2 Replies
View Related
Jul 8, 2015
I am in problem that I have delete data in my production table.
Now how to retrieve it?
I have only Yesterdays Full and Transaction Backup files.
I used the following query for deleting all data.
delete from t1;
View 7 Replies
View Related
Jul 16, 2015
Out of using stored procedure, reports and all this staff, I want to know the possible way to make sure that the data inside my Secondary Server Read only database are same as data in my primary server database.
So what is the simple way to do this check?
View 4 Replies
View Related
Aug 27, 2015
We have several read-only nodes in our AlwaysOn cluster, which are set to use Synchronous-commit mode, which ensures that the logs are updated on the read-only nodes before any update statements complete. Even with this option, if we query a read-only node before the logs have been processed, we can read old data. I would like to know a strategy to ensure that a read-only query will definitely return up to date information. I had an idea that if I just used a different transaction type, like Serializable, that it might block the read-only query from actually getting the data until after the log file was processed, but I have not tried it, yet.
I would like to move more queries to the read-only nodes, in an effort to offload CPU utilization from the primary node.
View 2 Replies
View Related
Jan 9, 2015
I'm trying to move a log file of a database that is part of an availability group. I have been following steps from the article: [URL]
At first this worked fine for me in a test environment. When I tried it in a production environment the database on the secondary went into "Recovery Pending" state and I can't get it out.
I checked to ensure that the dB is looking in the right place for the log file, and it is. It just doesn't seem to actually use the new file. If I start and stop SQL service, the dB comes back up and is fine.
Here are the steps I'm going through and what is happening at each step:
--------------------------------------
:Connect DEVSQL --This is currently PRIMARY
USE[master]
GO
ALTER AVAILABILITY GROUP [DP-AG-DEV] MODIFY REPLICA ON N'DEVSQL' WITH (SECONDARY_ROLE(ALLOW_CONNECTIONS = NO))
[Code] ....
All is good so far. Both the Primary and the Secondard have had their logical files changed, which has not taken affect yet because there has been no failover.
--Make SQL10 the PRIMARY
:Connect SQL10
ALTER AVAILABILITY GROUP [DP-AG-DEV] FAILOVER;
GO
SQL10 is now the Primary for this AG. And, as expected, the database [AG-Test] is in "Recovery Pending" because it is now looking for the log file in the new location. I need to move the file to the new location.
:Connect DEVSQL
--Enable XP_CMDSHELL
sp_configure 'show advanced options',1
go
reconfigure
go
sp_configure 'xp_cmdshell',1
[code].....
This is where the script is failing, returning the error:
Msg 1468, Level 16, State 5, Line 5
The operation cannot be performed on database "AG-Test" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
Msg 5069, Level 16, State 1, Line 5
ALTER DATABASE statement failed.
I can not get the dB to recognize the log file at it's new location.
If I restart the SQL Service, it comes back fine, which seems to indicate to me that it is not a permission problem and confirms that the file is in the right place.
How do I force SQL to look for the log file again without restarting the service?
View 2 Replies
View Related
Sep 10, 2015
If 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 Related
Jun 14, 2007
Please help!
Windows Server 2003 SE
SQL 2000 w/ 4
Veritas Netbackup 5.1 w/ MP5 (for backup/recovery)
Sometimes, not always, when I attempt to recovery a database I will follow the process of restoring the DB and it will complete with a status of successful. However when I attempt to view the DB in Enterprise Manager it states (loading) next to the DB - and never finishes.
As I said, this doesn't happen all the time, but of course when it happens I only know to start over, rebuild everything and go through the recovery process again. I am sure this is something simple.
I apologize for my lack of knowledge in regards to SQL.
Any insight greatly appreciated.
Thanks,
Kerry
View 8 Replies
View Related
May 19, 2008
Hi,
I want to drop my emp table.Is it possible to get back my emp table?
If possible pls give me the commands.
or give some useful website address
View 6 Replies
View Related
Oct 30, 2007
I have removed a SQL Server 2000 installation, as need to re-install the OS also backed up the whole "Microsoft SQL Server 2000" folder that contains all the MDF and LDF files of the DBs.
Now i also had some DTS packages there but now when i have re-installed the whole setup; i could not get the DTS packages. Is there anyway to recover the DTS as i have the whole folder that contains the SQL Server information. DBs are attached again but only the DTS are left. There must be some place where SQL Server stores this information.
Can anyone please help me out as its so urgent for my work.
Thanks!
View 1 Replies
View Related
Apr 24, 2008
After a crash while running a query, the database now has (In Recovery) next to its name and is totally unaccessible. How long does this is last? Is there something I should do about it or do I just wait?
View 5 Replies
View Related
Feb 22, 2008
hi.. how do i create a log entries with checkpoint for each transaction when accessing and updating the database?
i want to recover the data if in case of emergency....
also how do i check whether it has emergency during my project testing? haha.. i got an idea of switching of the electricity.. hahaha how should i do actually?
View 1 Replies
View Related
Feb 23, 2004
Hello,
I have a problem. I am trying to set up a disaster recovery plan and have ran into some problems. Just so you are aware, we have tried setting up replication but it failed since the database does not have primary keys(don't ask--I have no control) and we have tried to set up log shipping but we do not have the Enterprise version of SQL server so that won't work. The database is over 200GB so shipping by tape or transferring full backups across the wire is impractical. So basically my question is - "What other options can we explore for setting up disaster recovery that do not involve 'substantial' expenditures?"
There is a direct connection set up between the off site data store.
Thanks
View 12 Replies
View Related
May 11, 2000
I have the Master, Msdb and User Database dumps. I want to build another server with the avilable dumps.
Please help me....
Clark
View 2 Replies
View Related
Nov 15, 2000
Hey all,
Is there any that i can bypass the recovering of a particular
database when the server reboots? We are rebooting a prod. server
and we need to bypass the recovery of a particular database as
it is recovering forever. please help me out and i am gathering
the information from web as much as i can to get an idea.
thank you very much for the support
Andrew.s
View 1 Replies
View Related
