Pending Disaster
Nov 9, 2007
I am using SQL 2000 and have a major issue! I am new to SQL and not sure what to do about the license key being lost due to an update.
Background:
The server was originally loaded with a temp verison of SQL 2000 by the installer of the hardware until the Enterprise Edition arrived on site to insure that all the hardware worked fine. The Enterprise software was loaded onto the system and the license keys were installed. Everything has been working fine for several months. The server has been rebooted a few times after installing the license keys.
Trouble:
I loaded SP2 for Server 2003 and rebooted the server and now SQL thinks it is running the temp version and states that the license key has expired. I tried the suggested solution listed on the site of "upgrading with no changes" and the installation completes but never asks for my license keys. I rebooted the server and it states the samething thing that the temp has expired. It appears that one section can see the keys and another section does not. I have an active database that I do not want to loose but I am stumped on what to do to in order to re-install the license keys.
Any suggestions? Can copy the databases that I have created, uninstall SQL, re-install SQL from CD and then paste back my database? Will the databases restore correctly or is this to simple of a solution?
I have run out of ideas and options in order not to loose the database.
View 1 Replies
ADVERTISEMENT
May 15, 2008
i have a small doubt
where to see the pending transactions in transactional replication
For a database can we have multiple publications
View 2 Replies
View Related
Mar 28, 2006
Is there any command to check out any outstanding transactions not yet
replicated to subscriber DB? Thanks in advance
View 2 Replies
View Related
Apr 2, 2007
Hi,I have an application (Asp.net + c#).There is a SQL table called 'Status' it is used to store pending and activated events.There is a field called 'Complete'.So when user register I want to add recored to 'Complete' field as 'Pending'But I cant understand how to do this. Plese help me
View 1 Replies
View Related
Aug 18, 2014
How to find the pending transactions to be applied on secondary in Always On? Can i get those details from dashboard?
View 2 Replies
View Related
May 31, 2007
I've uninstall my previous sql2000 developer edition with leave some dll file undeleted.
once I tried to reinstall the sqlserver, the installation setup stop the process with message: A previous installation created pending file operations on the installation machine.
you must restart the computer before running setup.
I fail in continueing setup although i've restart the pc.
What should i do to handle this?
Regards,
BHT
Hhh.... please someone help me...
I don't want to reinstall the O/S as previously i've done. headache and waisting my days.
Regards,
BHT
View 3 Replies
View Related
Feb 20, 2007
I just installed SP2. I wanted to install the AdventureWorksDW database as part of the Database Engine Tuning Advisor tutorial. It said my install was not finished and I had a "pending reboot requirement." I shut down, and 8 different updates ran. When I tried to install the AdventureWorksDW database again, I got the same message. I'll see if there are still more updates to run.
View 10 Replies
View Related
Aug 2, 2006
We have VLDBs running on a SQL 2005 server. Some users have questioned speed and response times. When I investigated the server (W2K3) using the perfomrance monitor, I noticed an interesting questionabel result. The Repl. Pending Xacts showed 44,000,000 transactions waiting to be delived to the distribution databse. Problem is - we do not have replication tunred on on any of the db's on the box. In my research, I have not noticed anyone with a similiar issue. Does this amount of transaction take up space, or is it simply a counter that I don't have to be worried about?
View 4 Replies
View Related
Jun 30, 2015
i've change the database log file from E drive to Drive due to insufficient space.without attaching the log file i've shutdown the sytem. becz it's gone in hand mode.post resuming its showing recovery pending.i'm unable to get online db.
View 15 Replies
View Related
Apr 27, 2015
i have a SQL 2008 R2 RTM production instance, in which we run dBCC CheckDB every weekend to check on the DB. This weekend this sql job returned the error:
DBCC RESULTS
--------------------
<DbccResults>
<Dbcc ID="0" Error="8928" Severity="16" State="1">Object ID 866531312, index ID 1, partition ID 72057602979266560
, alloc unit ID 72057603064397824 (type In-row data): Page (1:7650240) could not be processed. See other errors
for details.</Dbcc>
<Dbcc ID="1" Error="8939" Severity="16" State="98">Table error: Object ID 866531312, index ID 1, partition ID 720
57602979266560, alloc unit ID 72057603064397824 (type In-row data), page (1:7650240). Test (IS_OFF (BUF_IOERR, pB
UF->bstat)) failed. Values are 12716041 and -6.</Dbcc>
<Dbcc ID="2" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 2 consistency errors in t
able 'tblDistpatch' (object ID 866531312).</Dbcc>
We tried to rebuild the indexes in the table: tblDistpatch...the non clustered indexes ran fine however the cluster index rebuilt returned an error:
Error: The statement has been terminated.
Msg 829, Level 21, State 1, Line 1
Database ID 3, Page (1:7650240) is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.in TEST environment we were able to reproduce this error by restoring latest backup.
we ran :
dbcc checktable (tblDistpatch ,REPAIR_ALLOW_DATA_LOSS )
then we ran dbcc checkdb and no errors where found.
my question comes with in your experience is this the best possible way to fix this table?only one table, but running this in production environment will required to put db in single user mode first.
View 7 Replies
View Related
Jun 12, 2015
I have a DB shown as recovery pending when running the following:
SELECT Name, state_desc
FROM sys.databases;
The DB was created by someone outside of our team using the Full Recovery model & I can see that no transaction log backups have been taken for this, causing the log to growth to a large size.
The MDF is only 5,120kb but the TRN has grown to 10,773,120kb
When I checked the Server I could see the data area had run out of space so I have freed up some space for this so now have 2.5gb available as a short term solution.
The MDF & LDF files are still visible & when checking the SQL log the DB is being reported as having a Full Transaction Log.
Essentially I want to change the Recovery Model from Full to Simple, Reduce the size of the transaction log & bring the DB back online. Luckily this DB is only used by a handful of users but I still need to get it up & running asap.
View 9 Replies
View Related
May 10, 2007
An issue with the 'Status' column of the 'Subscription' tab in the Report Manager.
I created Data-driven Subscriptions for some of the reports, and I scheduled the reports using shared schedule. The scheduling is working fine and all the reports are getting generated daily.
The issue is with the status of the report subscriptions under subscription tab, it shows as PENDING even after the report is generated.
I restarted the ReportServer database, it didn't served my purpose. The status never changes .
When do the subscription status changes to PENDING?
What needs to be done to change the PENDING status?
Is this the bug with the Report Manager?
Appreciate your timely help. TIA
View 5 Replies
View Related
Sep 15, 2004
I have a SQL2000 enterprise edition with sp3 clustered.
I am creating backup jobs via t-sql for around 680 databases. From MMC sqlAgent jobs, found all jobs (every DB has 7 jobs(M-Sun) are created. But some of (around 20% of the 680*7= 4760 jobs) in the Next Run Date column with value of "(Date and Time are not available". It means these jobs might be skipped to run.
If I right click the job and choose "start", then the job Next Run Date will be the corrent datetime. But when I rerun the t-sql to recreate jobs for these 20%, I get the
[The maximum number of pending SQLServerAgent notifications has been exceeded. The notification will be ignored.]
Is there a way to around it?
thanks
-D
View 3 Replies
View Related
Apr 11, 2007
Recently we disabled the transactional replication on a prodution database(data size:300GB) , two weeks later we were aware of the transaction log of that db almost reached the limitation (70GB).I investigated the issues and found:
1. open transactions pending for distribution:
DBCC opentran('xxxx')
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (323830:7083:1)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2. exec sp_replcounters, got over 240,000 replicated_transactions, which caused the tran log extremely large.
The transactional replication has been disabled on this server, there are no publication, distribution DBs any longer, all replication-related agents are also gone, why did this still happen???
3. use sp_repldone manaully reset those 240,000 transactions to distributed, check opentran, it was fine for a while. The tran log file was freed up 99% after that.
4. check open transactions and run sp_replcounters today, found the over 60000 transactions again on the db.
Did anybody experience the same issue and knows how to fix this issue and stop this happening ?
Many Thanks,
Henry
View 4 Replies
View Related
Jan 10, 2007
Have an interesting situation.
I have a NeverFail cluster on which I loaded SQL Server 2005 and SP1.
All was great. Both nodes had no issues with the initial setup or the SP1 update.
When I forced a failover to the inactive node, MOST of the services like SSIS, Full-Text and SQL Browser came up like a champ.
BUT ... the SQL Server service and the SQL Agent did not come up (or shall I say not fully).
I am now looking at the SQL Server Configuration Manager and I see the following for the SQL Server service:
"Name" shows the RED block icon for the SQL Server
"State" shows "Change pending ..."
"Start Mode" is set to Manual
"Log on as" has my domain account listed
"Process ID" has the number 2956 (so it has started somewhat).
I then click open the SQL Service item and it shows that it is stopped.
I am given the option to START the service. When I try to start it, the meter bar comes up and moves slowly to the end and then an error returns of ...
"The request failed or the service did not respond in a timely manner. Consult the event log or other applicable errors logs for details"
If I look under windows Services in the Admin Tools section... I see the services for SSIS, FT and Browser listed and started BUT I see SQL Server says its "starting".
If I click open the service from here, once again it show "starting" and all of the option buttons to Stop-Start-Pause-Resume are grayed out and I am not able to use them.
I have looked in the Windows Event Logs for any events but none are present.
Now I know why the SQL Agent is not running, and of course that is due to is dependency on SQL Server being up and running.
First off WHAT does the "Change pending" message mean?
Then what other logs can I look at for some help or is there someone who has the answers to this dilemma.
Thanks and have a great evening
View 11 Replies
View Related
Mar 16, 2015
Any command through that can I delete/disable the DWORD value "Pendingfilerename operations" so that while I start the SQL Install work, it does not fail due to this and can write this as one of the precheck options.
View 0 Replies
View Related
May 7, 2015
I have setup Transnational replication with updatable subscription.
There were around 7000 rows update at subscriber from one query which was executed at subscriber side.
But this update has not taken place at publisher yet and so to other subscribers.
Is there any way i can monitor pending log or where is the issue?
I find so many ways to see pending logs or statistics for - "Publisher to Subscriber" but not for "subscriber to publisher"
What is the way to see subscriber to publisher pending and issues?
View 0 Replies
View Related
Jan 12, 2013
I have a SQL cluster which ran out of disk the other day. I threw plenty more disk at the SAN. However, 1 of the databases came back with Recovery Pending and has been over 24 hours. I have tried to backup the database with no success. I don't have a clean backup from the day it occured so would have a good amount of work missing.
Running a dbcc check returns the following:
Msg 945, Level 14, State 2, Line 1
Database 'sqldb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I have not tried a dbcc check with REPAIR_ALLOW_DATA_LOSS as there seems to be a high risk of losing whatever was going on. how I can get the db back online?
View 10 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
Oct 1, 2000
I thought I had a good backup of my database, but it turns out my Backup Executive jobs were misconfigured and
my backup backup via MS Backup only grabbed the files that weren't in use. (.bak file)
I re-installed my Server 2000 to fix some other problems and now I've lost all my database. My wife (the MD) is
very upset over losing her schedule, billing info, and all her medical records. Whoops.
Anyway, I have two BAK files from one (and two) days ago, but when I replace them into the database, no data shows up.
The BAK files were created on an NTFS system, which is now running FAT32 - I don't think that should matter?.
Is there any hope or do I start typing?
View 1 Replies
View Related
Feb 2, 2001
Hi,
A test server I was developing on has died and all of my good work was on it.
However I have a copy of the Data folder containing the folloing files:
Test_Data.MDF
Test_Log.LDF
Is it possible to restore my database from these files?
If so how would I go about it?
Many thanks in advance!
View 1 Replies
View Related
Nov 16, 2001
We are having major hardware replaced on our W2000 Adv Server and we
need to be prepared to restore the entire system.
If the hardware fix goes badly, worst case, the plan is to
rebuild the server and then REINSTALL SS7 and
then restore all the databases from tape backups.
My question is, which database(s) should we restore first?
Should we restore master and then proceed to restore the user
databases or restore the user databases first and restore master last?
Thank you in advance.
View 1 Replies
View Related
Dec 23, 2002
I'm looking for something beyond trying to recover databases and/or SQLServer. My group has been tasked with documenting the recovery for 30+ servers that make up our applications infrastructure including SQL, Web, etc. I posted this here as opposed to another forum because I couldn't even find disaster recovery related topics in the other forums.
Our Systems group (Lan, Wan, etc.) isn't really much help at all. Their focus is more on the mainframe and Novell network recovery. Their perspective is that they will get any replacement server back on line in the event of failure but we are on our own from there.
There are three disaster scenarios for which we must plan: 1) A 737 does a nose dive into the Data Center. 2) A hurricane floods the Data Center. 3) A server gets smoked for whatever reason and is no longer useable.
Assume...
- that there were enough survivors to rebuild the network infrastructure at a remote site.
- we have to recover the operating system, additional software, IIS, SQL, applications, etc.
Questions:
What's the best way to capture the server's configuration on an automated basis?
What's the best way to recover the configuration mentioned above?
How do you maintain a current snapshot of any particular server and how do you ensure there's a documented history of the changes?
Does anybody use a centralized backup system? OmniBack, BackupExec?
What's the best/fastest way to get the replacement equipment?
Where else can I look to find this information?
Have I asked all the questions that I should or can you think of one I've missed?
Confused? Ask any questions you wish.
Sidney Ives
Database Administrator.
View 4 Replies
View Related
Mar 17, 2004
Yikes! I lost my autoloader bakcup device along with my SQL2K Server. I reinstalled Win2k and now can see my RAID partitions where I had SQL server installed, along with all of the files. Since my tape backup is dead, I cannot simply restore from media. I'd like to reinstall SQL Server and then somehow grab the files on the partition and restore all of the data back to where things were. Is this even possible? If so, could someone help me out? I am worried by reading this list that my primary application (Sharepoint) will not be able to be restored because of security issues. Any ideas on that?
I appreciate any help you can provide.
-Den
View 3 Replies
View Related
Oct 30, 2007
Hi Experts,
I am planning to create a disaster recovery site for my production database server. But I am not able to identify which option to choose. Not sure if I should go with database mirroring or transactional replication.
What are the pros and cons of each option?
Production and disaster recovery site location will be geographically very far.
please help
Regards,
S
Don't sit back because of failure. It will come back to check if you still available. -- Binu
View 1 Replies
View Related
Feb 25, 2008
I'm looking for a proven method and documenation on recovering a publisher that is also the distributor. I have had problems with subscribers failing and database corruption on subscribtion databases. I do not have any documentation or experience in recovering a publisher that also is it's own distributor. Please point me in the right direction for this and any in house documentation that may not be published to the public would be great.
View 2 Replies
View Related
Nov 24, 2006
I used to have WSS 3.0 Beta version, to update that to B2TR i got a problem and for which i require to reinstall the WSS again. Now I have the old WSS_Content.mdf and WSS_Content.ldf. I want this old site content tranfer to the current one.
How can I restore the data of this Site Content Database to the new one which I have newly created.
The mdf size is 3 gb and the ldf is nearly 8 gb.
Immediate response is highly appretiated.
Regards,
Raj
View 3 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
Oct 23, 2015
I have a query which sends email notification of count of pending name and suggested name.. on a daily basis. So this works fine but now I want like if the pending and suggested are ' o count' I don't want the email notification. It should not send an email, if it is o count, but if we have the number for pending and suggested this email should be sent.
View 8 Replies
View Related
Jan 15, 2001
Recently I watched Microsoft Support WebCast: Microsoft SQL Server 7.0 Common Problems and Resolutions dated August 29, 2000. I am trying to find information for a total disaster recovery for my server. In the webcast the presenter made a reference to a Microsoft article Q240872, "How to Resolve Permission Issues When a Database is Moved Between SQL Servers?". I can't find this article. Since we are working with the scenerio of total diaster, we are starting with a new server. I know that when we tried to recover a database to a new server, the server recognized that the database did not originate on that server. Does anyone have any ideas? Or does anyone know how to contact Microsoft so I can find out how to get a copy of this article?
Thanks!
View 2 Replies
View Related
Nov 15, 2000
What is the best recovery plan consist of??
Backup : Full and Transaction log.
Hardware : Clustering, RAID
I am not sure about what all need to be Scripted for having a good disaster recovery plan??
Scripting:: tables, views, defaults, rules, users, roles, permissions
Backup : Triggers, Stored Procedures
Your inputs are appreciated.
Sneha
View 11 Replies
View Related
Jan 21, 2000
Hi friends,
My company is planning to do exercise for disaster(complete server screwed up). They don't want to add the users or jobs. They are asking me to restore Master,Msdb and User Databases. I Planned like this if there is any mistake please reply me ( It is urgent)
1.Installing NT, IE and MS sql server 7.0. with all appropriate service packs.
2.Creating User databases which were present on the previous screwed up server with same name.
3.Restoring Master Database and Rebooting the server.
4.Restoring Msdb Database and Rebooting the server.
5.Restoring the User Database along with the transaction logs.
6.Running 'DBCC checkdb' command on all the databases.
Please reply me soon.
Thanks
dindu.
View 5 Replies
View Related
