Hard Drive Trashing After SP2 + KB934458

Apr 5, 2007

Hi. Has anyone else had any problem with their SQL Server 2005 going nuts after installing the SP2 + the above hotfix?

We reboot the SQL Server and as soon as SQL receives a command of any sort, the SCSI RAID 5 hard drives light up and start trashing. Therefore every query and even Windows response time is painfully slow or fails to respond. When we look at the Activity Monitor and sp_who2 there is a process running a Select Into from Microsoft SQL Server Management Studio using the sa account from the last database name in our system. So we can't kill the process as it says "Cannot use KILL to kill your own process. Microsoft SQL Server, Error: 6104)".

The last Transact-SQL command from this process is:
create table #tmpDBCCinputbuffer ((Event Type) nvarchar(512),
[Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(56)')
select [Event Info] from #tmpDBCCinputbuffer

The only other issue I should mention is that we had to uninstall and reinstall SQL Server yesterday as SP2 only half installed. The SP2 install log indicated that SQL SP1 wasn't in a good state as we previously (3 months ago) performed an upgrade from Windows 2000 Server to Windows 2003 R2 Server.

Our other 3 Windows 2003 R2 Servers which were a clean install of both Windows and SQL are running fine.

I've been insisting that we do a new clean Windows and SQL install, but the other team members insist that it's been fine until we installed SQL Server SP2.

So can anyone provide and help or evidence to say who is right either way?

Thanks.

View 3 Replies


ADVERTISEMENT

Reconfigure NT Hard Drive

Nov 14, 2000

hi, I have NT server which has drive c: 500 MB and drive d has 44 GB.

I know that the person who set up this server did not give enough space to the c drive, here is the problem. I am running sql server 7.0 which has 30 GB of data in the d drive. I need to reconfigure the NT hard drive so I can allocate 2 GB for C drive and 42 GB for D drive.


What is the best, safe method to accomplish this task.

Ahmed

View 3 Replies View Related

Hard Drive Failure

Sep 27, 1999

After experiencing a hard drive failure i have reinstaled MSSQL7 on one drive and have a database which I need to recover on separate physical drive. How can I go about doing this?

View 1 Replies View Related

Hard Drive Status

Jul 17, 2003

Hi,
I have ran
1. xp_fixeddrives and got the result
drive MB free
----- -----------
C 1708
D 16311
2. I ran Backup Wizard in EM and able to see only above drives

3. But if ran backup in EM able to see more than 10 Drives(like C,D,H,I,J,M,N and etc).
Why I can able to see those difference?.
How do I find out exactly how many drives are there in this server without directly going to that server?.
I appreciated your valuable answere.
Thanks,
Ravi

View 8 Replies View Related

The Hard Drive Configuration

Apr 7, 2004

Hello, everyone:

Does any one have an idea for hard drive configuration on SQL Server 2K? How to determine the RAID level for datafile and log file? Thanks

ZYT

View 2 Replies View Related

Formatting The Hard Drive

May 18, 2004

I was wondering if anyone played around with changing the allocation unit size when formatting the hard drive the SQL server is running on. I would think that setting it higher to account for the larger size of the database files would help, but I'm not sure.

Anyone have any thoughts?

View 3 Replies View Related

Hard Drive Setup Question

Feb 2, 2007

Hi guys,

I have a general question. Would SQL server have slower performance if you placed the ldf or mdf files on a dynamic drive setup or should it always be basic? I noticed that a server had 2 dynamic drives and the log files and mdf files are located on these drives. Usually I see all the drives as basic not dynamic. Does this even matter?

thanks

View 1 Replies View Related

Backup To Non-local Hard Drive

Oct 19, 1998

I want to perform backups to a network drive. I need to know if I can access the backup drive via UNC. I have not been able to get it to work and, for now, I would just like to know if what I am trying to do SHOULD work.

For example I want to backup to device mdtnts_prod02LM2BackupNameBack.DAT.

Thanks,Bob

View 1 Replies View Related

Hard Drive Defragmentation Opinions

May 9, 2008

I'm wondering what other people do in regards to running hard drive defragmentation programs on SQL Server 2005 servers (assume 64-bit and Windows 2003). From what I can tell the most common opinions are:

1. Don't defragment because it doesn't help and it can cause problems.
2. Use Diskeeper
3. Use the built-in Windows defragmenter

Other respected defragmented programs are PerfectDisk, O&O Defrag, JkDefrag, and Contig.

What is your hard drive defragmentation strategy?

View 1 Replies View Related

Need Help Approximating How Much Hard Drive Space I Need For My DB Table.

May 12, 2007

In our SQL Server database we will have a table that will be populated with about 2000 recordsper day. That is 2000 records per day for 5 days per week. Currently the computer we are using has about  50 gigabytesof available hard drive space on it. We are concerned that maybe we will need a bigger hard drive,based solely on the number of records entered into this table per day. The problem is I don'tknow how to calculate how much hard drive space we need. I think I read that using varchar,sql server 2005 really optimizes a database. Here is a typical example of data in ourdatabase. I put dots on three lines between the first and last sample record to justillustrate that there are many records in between.
Basically we only need 8 months of data at a time in the table and then we can purgerecords older than 8 months.Can someone help me approximate how much hard drive space I might need for 8 months of data,given the following sample record in the database?
Sample: -->34.5               4.08        10.6       .0012
Sample Table in my DB just for illustration:
(PPsquare inch)  (Diameter)  (Weight gm)     (coeffOfSatFriction)
34.5                      4.08            10.6                .0012...21.7               3.54        6.22         .019

View 4 Replies View Related

Copying Sql Table To Computer Hard Drive

Nov 26, 2007

Hi,
 
I use sql server management express. I have created a table on my hosts remote database and i want to copy the table (or the data) in some format or other to my hard drive. does anyone have any good ideas how i may do this either through management express or other means.
thanks a lot
nick

View 2 Replies View Related

Help SQL Server 7 Dump Data To Hard Drive

Feb 20, 2004

Hi,

I am running sql server 7 with 200+GB database size. I have one table with following fields

IIINDEX
DOCTYPE
IMAGE BLOB

I need to dump all the information from this table to hard drive.

I have try with delphi ado and delphi odbc (limit 1mb), somehow when I run the program it gives me an error message E_ timeout.

How can I dump this information without using delphi.

Any help will be highly appreciated.

If you have any code that can help please email me samirp@ix.netcom.com

Thanks.

Samir

View 1 Replies View Related

How To Recover SQL Database From A Removed Laptop Hard Drive?

Jul 23, 2005

Dear group:I have removed my hard drive from my laptop (which is now toast) andhave managed to recover nearly all the data from it by installing thedrive into my desktop. I was hoping to reboot the dektop to see if Icould load the operating system on the laptop's hard drive so I coulddo a manual backup of the SQL database on it. This does not work.Does anyone know of a way to recover my SQL database and all its tablesgiven the circumstances above?TIAISZ

View 5 Replies View Related

With New Hard Drive- Error 3: The System Cannot Find The Specified Path

May 5, 2006

Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following:

Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path.

1. What could be wrong?

2. How do I fix it?

View 9 Replies View Related

Read Binary Data From Table And Save On Hard Drive

Oct 18, 2007

Hi all,
I have one table with a column of type 'image'. There are manytypes of files saved in that column (i.e. .Doc,Xls,Pdf,jpg,gif etc.). What I want is, read that files from database and save it in temp folder on d drive of server. Can anyone help me in my problem?
Thanx in advance

View 1 Replies View Related

Hard Drive Crashed. Master && User Db Mdf && Ldf Files Lost

Jan 31, 2006

Hello.

One of our hard drives has crashed and as a result we have lost our master mdf/ldf & user db mdf/ldf files. It's not that a critical system by any means, but if the hard drive crashes and the master mdf/ldf files & user db mdf/ldf are lost, is there any way of restoring the system?

I'm thinking we probably need to re-install Enterprise Manager completely, and re-install the user db from a backup.

Any advice/suggestions would be much appreciated.

Thanks in advance,

View 1 Replies View Related

Installing Sql 2005 Management Studio Express On 2nd Hard Drive

Apr 25, 2006

Hi,

I've downloaded the sql server 2005 management studio express executable to my second hard drive, as there is no room on my main drive

However, when I try to install, the program shows me both drives, and shows that there is not enough room on my main drive, but it does not allow me to change the installation to my second drive.

I have previously installed the main sql express product to my second drive with visual studio. There's loads of room.

Can anyone give me a clue as to why this might be happening.

Thanks

John

View 1 Replies View Related

Need To Create And Access A SQL Server Database That Will Reside On An External Hard Drive.

Apr 9, 2007

 
 I need to create a SQL server database and add some tables to it. Then access it with a C# application. The problem is that the new SQL server database and it's tables must reside on an external hard drive. How do I point SQL server to this external drive, so that I can create a database on this drive and then create tables and access data on it?
 
 

View 7 Replies View Related

Trouble Installing Hot Fix KB934458

Apr 6, 2007

Greetings all,

I am having trouble getting the Critical Update for SQL Server 2005 Service Pack 2 (KB 934458) to install successfully. Message simply states the updates was unsuccessful. After that I am unable to connect to SQL Server via SSMS. Only rebooting the computer allows me to reconnect. Then Automatic updates won't leave me alone and wants to try it again. Hmmmmm.



I then tried to download (SQLServer2005-KB934458-x86-ENU.exe) and try it again. While running the update I noticed it was now referred to as "Microsoft SQL Server 2005 Service Pack 2 Cumulative Hotfix 3054". Are these the same thing? Any hoot, it still fails to install. As each component failed, for what looks to be the same reason (See below), I allowed the installation wizard to report it's findings back to Microsoft.



Oh and one other observation. It appears as though Microsoft had a similar issue when they release SS2k5 SP1. They issed a workaround. See http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918357. If this is the same problem, why wouldn' t they try to fix it before releasing SP2?



Any way back to my current issue, clicking on the View Summary at the Installation Complete dialog reveals the following. Can someone help?



Thanks!!!



Time: 04/06/2007 10:04:01.859
KB Number: KB934458
Machine: PEPE
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3054
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
SQL Server Database Services 2005 (MSSQLSERVER) ENU SP2 2005.090.3050.00 x86 DEVELOPER
SQL Server Analysis Services 2005 (MSSQLSERVER) ENU SP2 2005.090.3050.00 x86 DEVELOPER
SQL Server Reporting Services 2005 (MSSQLSERVER) ENU SP2 9.00.3050.00 x86 DEVELOPER
SQL Server Notification Services 2005 ENU SP2 9.00.3050.00 x86 DEVELOPER
SQL Server Integration Services 2005 ENU SP2 9.00.3050.00 x86 DEVELOPER
SQL Server Tools and Workstation Components 2005 ENU SP2 9.2.3050 x86 DEVELOPER

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : SQL Server Analysis Services 2005 (MSSQLSERVER)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB934458_sqlrun_as.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : SQL Server Reporting Services 2005 (MSSQLSERVER)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB934458_sqlrun_rs.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : SQL Server Notification Services 2005
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB934458_sqlrun_ns.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : SQL Server Integration Services 2005
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB934458_sqlrun_dts.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB934458_sqlrun_tools.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1635



-------------------------------------- End of View Summary ---------------------------------------

For information purposes I went ahead and included below the tail end of the first failing process where it looks to go cattywhompus. The end of the log file (highlighted in yellow above) looks like this:

...

MSI (s) (10C) [09:51:23:343]: Opening existing patch 'C:WINDOWSInstaller2a6c7048.msp'.
MSI (s) (10C) [09:51:23:343]: Note: 1: 2203 2: C:WINDOWSInstaller2a6c7048.msp 3: -2147287038
MSI (s) (10C) [09:51:23:343]: Couldn't find local patch 'C:WINDOWSInstaller2a6c7048.msp'. Looking for it at its source.
MSI (s) (10C) [09:51:23:343]: Resolving Patch source.
MSI (s) (10C) [09:51:23:343]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (10C) [09:51:23:343]: User policy value 'DisableMedia' is 0
MSI (s) (10C) [09:51:23:343]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Adding {4A35EF4A-D868-4B15-A84D-3E8925AA9558}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Now checking product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Media is enabled for product.
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Trying source d:e2ba478890840dab90ccafHotFixSQLFiles.
MSI (s) (10C) [09:51:23:343]: Note: 1: 2203 2: d:e2ba478890840dab90ccafHotFixSQLFilessqlrun_sql.msp 3: -2147287037
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (10C) [09:51:23:343]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Processing net source list.
MSI (s) (10C) [09:51:23:343]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp
MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Processing media source list.
MSI (s) (10C) [09:51:23:359]: SOURCEMGMT: Resolved source to: 'sqlrun_sql.msp'
MSI (s) (10C) [09:53:21:359]: Note: 1: 1314 2: sqlrun_sql.msp
MSI (s) (10C) [09:53:21:359]: Unable to create a temp copy of patch 'sqlrun_sql.msp'.
MSI (s) (10C) [09:53:21:390]: Note: 1: 1708
MSI (s) (10C) [09:53:21:390]: Note: 1: 2729
MSI (s) (10C) [09:53:21:406]: Note: 1: 2729
MSI (s) (10C) [09:53:21:406]: Product: Microsoft SQL Server 2005 -- Installation failed.

MSI (s) (10C) [09:53:21:437]: MainEngineThread is returning 1635
This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package.
C:WINDOWSInstaller9b7a85.msi
MSI (c) (C0:90) [09:53:21:437]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (C0:90) [09:53:21:437]: MainEngineThread is returning 1635
=== Verbose logging stopped: 4/6/2007 9:53:21 ===











View 9 Replies View Related

Failure Applying Hot Fix KB934458

Dec 26, 2007

Our update of KB 934458 to SQL Server 2005 SP2 has failed on a Windows 2003 SP2 server. This is a standard version of SQL Server.

The error reported is:

Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file e:MSQLMSSQLData for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.

I have verified that Administrator has full control permissions for the folder indicated in the error message. The SQL Server Service account also has full control permissions on the folder.

I have run the update as administrator without any access restriction.

Any advice will be appreciated.

Thanks

View 1 Replies View Related

Cannot Save Maintenance Plans (SQL Server 2005 X64, SP2, Patched To KB934458)

Nov 18, 2007

I have a SQL Server 2005 x64 bit with SP2 applied and patched to KB934458-x64-ENU (9.0.3054)
I am unable to create a maintenance plan via Management Studio or save a plan in Management Studio using the wizard.

If I just try and create a new maintenance plan, then I get the following problem:
"An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed."

If I try and create any maintenance plan via the wizard, I get the following problem:
"The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed."

I've doen a bit of digging on this and had initially thought it was related to the fact that I have two instances installed on 1 server. I've since updated the MsDtsSrvr.ini.xml file to point at both instances, as I thought that might have been causing the problem. That hasn't helped at all. Edited example of xml file is below:

<?xml version="1.0" encoding="utf-8"?><DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB SQL Server Instance 1</Name> <ServerName>ServerNameInstanceName1</ServerName> </Folder> <Name>MSDB Server Instance 2</Name> <ServerName>ServerNameInstanceName2</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>

Any suggestions would be most welcome!

View 4 Replies View Related

Can I Used A Shared Drive Rather Than A Mapped Drive With OpenRowSet?

Apr 4, 2008



Hi

I have been trying to use openrowset with a shared drive, and even though the share has "full control" permissions granted to "everyone" and the accout that SQL runs under has been granted explicit full control permissions I am unable to open the file which itself has no security on it.

Can I not use a \ path and only use mapped drives?

Thanks

below works...

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:5People.xls', [Sheet1$])

below doesn't work...

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\cluster02FileManager5People.xls', [Sheet1$])

View 3 Replies View Related

How To Move A Log File From &#39;e&#39; Drive To &#39;f&#39; Drive....

Nov 9, 2000

I am trying to move a log file from one drive to another.

What I have done is add another file to my file group. So now my log has a file on the 'e' drive and one on the 'f' drive. I now want to remove the file on the 'e' drive. I have emptied the file on the 'e' drive. When doing the command:

ALTER DATABASE Uniprodruntime
REMOVE FILE m_rk_runtime_log

I get the following error message..

Server: Msg 5020, Level 16, State 1, Line 1
The primary data or log file cannot be removed from a database.

I have also gone into enterprise manager and tried to delete the file and it does nothing.

Has anyone run into this?

View 2 Replies View Related

SAN Drive Speed Vs Local Drive

Feb 12, 2007

How do you compare SAN drive vs local drive on a 32 bit server?

Is it good idea to move my DB files to a SAN instead of local?

Canada DBA

View 4 Replies View Related

TempDB Keeps Getting Filled And It Is In C Drive But It Should Be In T Drive

Nov 28, 2015

Server: SQL 2008 R2

 1: TempDB keeps getting filled.  Restart of the server has not fixed it. I shrink it, but the space gets filled again. Now I can't even shrink it anymore
2: TempDB is at the wrong location. Its current location is this :C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb

How do I change its location? 

C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb
Correct location of TempDB should be: TempDB(T:) But its not there

View 13 Replies View Related

SQL Server Upgrade MSP Error: 29538 On KB934458 Upgrade

May 13, 2008


We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got the following error as stated in the Summary.txt file.




Code Snippet
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
----------------------------------------------------------------------------------






The client tools and workstation components were successfully installed. The server is still reporting build 3042.

Here is the portions of the HotFix.log file.




Code Snippet
05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
05/12/2008 09:19:09.072 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug"
05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
05/12/2008 09:22:33.678 MSP returned 1603: A fatal error occurred during installation.
05/12/2008 09:22:33.724 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"






Any help would be appreciated.

View 3 Replies View Related

Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive

Jan 31, 2008

Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View 4 Replies View Related

SQL 2012 :: How To Backup Half Of DBs From A Server On C Drive And Other Half On D Drive

Jan 16, 2015

How to backup half of dbs from a server on C drive and the other half on D drive and vice versa, first half on D drive and other half On C drive using only one job and one stored procedure??

Using scheduling from job add 2 schedules to the job so first schedule backup first half to C and second half to D , the second schedule backup first half to D and second half to D.

View 1 Replies View Related

HARD TOP SQL PROBLEM PLEASE HELP

Apr 5, 2005

Hi,
I need to use a top and a join in the same sql. To get 10 top refnr from orders_refnr. That works fine to I use this:
SQL = "SELECT TOP 10 refnr, antal = COUNT(refnr) FROM orders_refnr INNER JOIN produkter ON (orders_refnr.refnr = produkter.referensnummer) GROUP BY refnr ORDER BY antal DESC"
But I need to be able to get information from more fields than the field refnr. How can I specify more fields? I need to get other fields from produkter.
Please helt I´m really stucked.

View 4 Replies View Related

Is This SQL Test Too Hard?

May 17, 2007

I have gotten some criticism from coworkers regarding this test and just wanted to see what you guys think. I realize the wording could use improvement and any criticism towards making it easier to understand is much appreciated.FWIW - I had to solve this problem on the job so I feel it is a real-world test that helps me understand how people think and if they try to find alternate solutions.Thanks!~~~~~~~~~~~~~~~~~~~~Given a table that has over 100,000 records…SUBSIDIARY=========PARENT_IDINTCHILD_IDINTULTIMATE_PARENT_IDINTCLEANUP_INDBIT…where each PARENT_ID can have multiple CHILD_ID values, but the PARENT_ID should not equal the CHILD_ID. After an initial data load, the ULTIMATE_PARENT_ID and CLEANUP_IND columns contain NULL values (see page 2 for sample data).ULTIMATE_PARENT_ID is defined as the topmost parent in the chain for the particular CHILD_ID record, so if the chain was only 2-level’s deep the ULTIMATE_PARENT_ID is the CHILD_ID’s PARENT_ID’s PARENT_ID.Please write an answer for all three questions below:A)Which of the following queries should you run first?B)Write an optimized query to identify the ULTIMATE_PARENT_ID for each CHILD_ID and set its value into the ULTIMATE_PARENT_ID column.C)Write a query to identify ALL of the circular references and mark each record that is a circular reference by updating the CLEANUP_IND column to 1.~~~~~~~~~ Page 2 ~~~~~~~~~ Sample Data, remember though this table has over 100,000 records and the parent-child chain can go n-levels deep – where n is not known.PARENT_IDCHILD_IDULTIMATE_PARENT_IDCLEANUP_IND1024512NULLNULL362300NULLNULL887541NULLNULL10221024NULLNULL546887NULLNULL5122305NULLNULL112967NULLNULL697123NULLNULL901452NULLNULL2300666NULLNULL334445NULLNULL512903NULLNULL884554NULLNULL313313NULLNULL554884NULLNULL112119NULLNULL967555NULLNULL2305333NULLNULL33336NULLNULL541546NULLNULL10301020NULLNULL112999NULLNULL

View 14 Replies View Related

Hard Query

Feb 13, 2006

hello

i have a proplem in query

i have 2 tables in my sql db one named stuednt include fields(id,name)

and one table named stu_cources include fields(id,course_name)

ok

i want to query the student that have courses EX. mcse

the result that i want from 2 tables

ID | NAME | Coures_NAME

in MSHFLEXGRID1



any one help me plz ...

View 4 Replies View Related

Monitor Hard Drives

Jul 30, 2001

Hi, I'm looking for a way to check the free space left on the hard drives and then if needed send an alert to notify when we need to free up some space. I played around with the performance monitor and realized I could do it that way but I think you would have to leave the performance monitor running all the time and I'm not sure if I want to do that. I also read about the xp_fixeddrives proc that displays how much free space is available but then I don't know what to do from there? Does anyone have any recommendations for the best way to do this.

View 3 Replies View Related

SQL Sorting Question (hard One)

Feb 19, 2007

Right, I have this database that I need to sort, I'll give you an example:

ID Name Value
2312 Sega 200
5678 Blizzard 215
3412 Bullfrog 210
6798 Nintendo 195

Now, what I need to do is to sort it, perform calculations on and I need the list to be sorted with a predefined post as the top result, say like this one time:

ID Name Value
3412 Bullfrog 200
2312 Sega 210
5678 Alizzard 215
6798 Nintendo 195

as you can see sorting it alphabetically would lead to

5678 Alizzard 215
3412 Bullfrog 210
6798 Nintendo 195
2312 Sega 200

(or the other way around if you play with asc/desc)
by id would be

2312 Sega 200
3412 Bullfrog 210
5678 Alizzard 215
6798 Nintendo 195

There aren't any top or bottom values sort of speak for the posts I want to be on top, so...how to sort this like this?

3412 Bullfrog 200
2312 Sega 210
5678 Alizzard 215
6798 Nintendo 195

the order after the top one is irrelevant.

Now...I know I could sort this by doing something like

"Select * FROM blablabla WHERE Name = 'Bullfrog'"

and then doing "Select * FROM blablabla" and then just bypassing that post in asp/php code or whatever, but that would be a pain for me to do as I have to perform some massive calculations and the code would be alot larger then needed be

Its a brain teaser allright...can you help me out?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved