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 RepliesAny 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 Relatedi have a small doubt
where to see the pending transactions in transactional replication
For a database can we have multiple publications
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.
Is there any command to check out any outstanding transactions not yet
replicated to subscriber DB? Thanks in advance
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 RelatedHow to find the pending transactions to be applied on secondary in Always On? Can i get those details from dashboard?
View 2 Replies View RelatedI'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
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 Relatedi'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 Relatedi 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.
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.
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
Hi
I am looking to buy an SQL server2005 with 5 CAL's for my company in UK to fulfill our database management requirements. There seems to be a big difference between the US and UK prices. The US prices are somewhere around half the price of what i could get in UK. Are there any tax implications if i order one from US. Would there be any problems of registration if i buy from US. Any answers would be greatly appreciated.
I need to order them asap.
Thanks
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
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
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
i HAVE one requirement in a table. that is column1 for first record value 100next record 101next record 102next record 103for next 104I want to update that table daily with this requirement.not with identity columnnext day 100 may be 220,339, some thing random numberlike this how can i update a table column1
View 2 Replies View RelatedHello,
Anyone aware of any license requirment for selling any application developed in ASP.NET (C#) using MSDE as backend?
Any response will be highly appreciated.
Thanks
Windows 2003 came in the market already.
Yukon is going to release soon.
Will SQL Server 2003 run better on Windows 2000 Server, or it will run better on Windows Server 2003?
Anybody know?
Hi Experts ,
I want to insert datas randomly to all columns of a table.The columns have different datatypes like int,varchar,datetime. What to do??? It is urgent so please help.
TIA
RKNAIR
Is there any recommendation of how to calculate what would be a suitable hardware requirement for running a huge database on Production. I have a database with over 150GB of data. The server has 1.5GB memory. The database is indexed. The size of the database will most probably exceed over 400GB of data. Is there any recommendation on how much memory / hardware to put on the box.
Also on a side topic, how do large sites (example - microsoft forum) keep storing information in a database and still allow fast searching? Do they move old info to another database... But I am able to search across old information as well.
Hello, this is Subhani .
I am installing Sql 2005 standard version.
The problem is that while I am installing Sql 2005 the two warning messages are given that €œcom plus catalog requirement€? & €œminimum hardware requirement€? So please suggest me, what I have to do to install successfully
Hi experts,
We have SQL Server 2005 installed in MS Windows server 2003 with 8 GB RAM. This server has 4 processors.
Ours is a VLDB and a single table has 400 million records occupying nearly 40 GB of space.
We find it vert difficult to meet the response time set by the clients in many occasions.
Should the RAM be atleast as big as the biggest table in the database ? Is this mandatory ?
Even any other suggestions for improving the performance are welcome.
Thanks & Regards,
Hariarul
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?
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?
Hi,
I am not even sure where and what to do on this requirements
"If the system crashes before all the information during transaction fails, none of those changes will be saved to the database."
what kind of info you need from my DB?
no clue.
thanks
Hello there
I installed sql server 2005 developer edition
and the only error message i got was.
- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
how do i get hold of Internet Information Services
I installed it on vista premium.
Please help
Regards
ROB
We are running four servers at different sites say A,B,C and D and wantit to connect main Server at head office what would be theconfiguration of main server for running SQL Server 2005.There are twodatabase say X and Y at each server at sites A,B,C and D. X requires37.4 MB memory while Y requires 154 MB memory. 500 records arepopulated in X database at each site While 30000 records are populatedin Y database at each site. What would be HW requirement for SQLServer?With regardsAli Raza Rajput
View 2 Replies View RelatedHi, I read throught the requirements of installing SQL Express and found that one of the requirement stated Microsoft .NET Framework. As I'm now developing my application in VC++(MFC), it's not build on .NET Framework. I wish to know in my case, can I use SQL Express in my application? Thank in advance.
View 4 Replies View RelatedI am in the process of learning SQL from scratch and figure it would be helpful if I can run a local server and experiment with it as I move along some book reading. I have a few questions regarding the operating system requirement for running a localhost server and hope some of you can answer to my novice questions. Can I setup a server under Windows XP? when I looked thru the documentation it indicated only windows 2000 and other Microsoft server OS will support a SQL server setup. Why then it also indicate XP as compatible? Is it because it's compatible as a client? If I do have to run a server under a different operationg system, what is the best approach for setting up another server on my only PC system along with my XP. Thanks for any answers and comments in advance.
View 7 Replies View RelatedI have developed a client server application using SQL Server 2005 Express and VB.Net. I will be distributing it to my customers. I am putting together a System Requirement document. I am wondering what kind of Server (o/s) and network configuration customers need to have. I know they cannot use a pier to pier network setting. What kind of network setting do they need to have? Does the server machine need to have a server o/s (such as Win 2003 Server) or is Windows XP fine? Any help will be appreciated.
View 3 Replies View RelatedHi friends
this is the Orders to rise the publisheres (Titles or magzines).
I have two tables
1) orders Tables the columns are like orderno int , titleId int ,ItContaincomb bit, combinationID int.
Values(1,2,null,null)
values(1,3,null,null)
values(2,4,null,null)
Values(2,3,null,null)
values(2,2,null,null)
values(3,4,null,null)
2) CombinationTable containg columns like CombId int , Titleid int.
values(101,2)
values(101,3)
values(102,4)
values(102,5)
valus(103,2)
values(103,4)
my requirement is in orders table the last twocolumns should be filled by checking the combination table
1)
take 101 combination containg 2,3 titles check these all titles are containg or not . if Compulsory all titles containg means in orders table we put
ItContaincomb true, combinationID 101 for all containg titles.
if not containg single title in orders table for combination 101 means
we put that titleid rows should containg column of ItContaincomb is false and combid is 0.
i want below out put for above two tables how to write a query or how to use all function.
the output is (in orders table)
Values(1,2,true,101)
values(1,3,true,101)
values(2,4,false,0)
Values(2,3,false,0)
values(2,2,true,103)
values(3,4,true,103
please help me .
thanks regards
venkat