Restore System Dbs From SP3 To SP3a?
Jan 14, 2005Can system databases (master, model, msdb) backed up from SQL2k SP3 be restored to an instance of SP3a? Can they be restored from SP3a to SP3? TIA!
View 4 Replies
ADVERTISEMENT
SQL Server Admin 2014 :: How To Do System Restore To Previous Restore Point
Dec 31, 2014In Windows Server 2012. How do I do a System Restore to a previous restore point?I need to install the 64 bit and 32 bit Oracle Client Install for connections in SSIS and to create Oracle Linked Servers.
If you make a mistake it is not fun removing it. Sometimes it corrupts the machine and it is difficult to uninstall since there is not an Oracle Universal installer for Oracle 11g.If you install the 32 bit before the 64 you mess up the machine.how to create a restore point.
Restore All System Databases
Feb 8, 2007Hi All,
I need to do a restore of all my system databases, master, msdb and model, and of course my production database.
The Windows 2003 OS and Sql Server 2005 have both been reinstalled on the server.
I understand I need to be in Single User Mode to restore the master database and I just wanted to clarify the procedure for a successful restore.
I've found this page: http://msdn2.microsoft.com/en-us/library/ms190679.aspx which has instructions for restoring a master database.
So, all I have to do is:
1. Be in single user mode
2. Using SQLCMD run:
C:> sqlcmd
1> RESTORE DATABASE master FROM DISK = 'Z:MyBackLocationmaster.bak';
2> GO
From the instructions:
"After master is restored, the instance of SQL Server shuts down and terminates the sqlcmd process"
My Questions:
When I've restored the master do I repeat the steps above to restore the msdb and model databases?
Are there any other pitfalls?
Thanks for any advice
Melt
HELP Lost DB, Restore From System Backup Not SQL
Sep 3, 1999I have to restore a database from a directory structure backup run by NT SERVER not SQL SERVER. I am not sure of the database size structure or whethter it has a log device. I am desperate for any advice on methods of restoring this in a safe manner.(it is a live production DB)
Thanks in advance.
Barry.
Question On System And Data Restore
Sep 20, 2006new to SQL Server 2000. We have an obsolete database that we need tosave off for x number of years. DB2 has utilities (DB2Look/Export)that allows for the export of the data along with a schema and scriptthat enables the future recreation of the structure of the databasesand tables to include RI etc. You can save off the architecture andrelationships of the tables as well as the data.Does SQL Server have anything similar?Thanks in advance.Gerry
View 3 Replies View RelatedPrevent Backup And Restore On Different System
Sep 24, 2007
How do I prevent someone from backing up the data / copying the mdf and then mounting it from a different server or instance to gain access to the DB.
I do not have control over the physical file.
Basically, I want to make sure that only authorized applications and users can access the data.
Is It Neccessary To Restore System Database For New Server?
Dec 14, 2007Hello, everyone:
I am going to remove a database server (SQL Server 2000 on Win 2003) to a brand new server, same as SQL Server 2000 on Win 2003. Do I need to restore system database(master, msdb, model and tempDB) to the new server? My understanding I don't have to because I will transfer DTSs and login user by DTS to new server, and run scripts to recreate jobs on new server. Is it correct?
Thanks
ZYT
Restore Data From Live System To Test
Jun 16, 2015I have two SQL Databases on separate servers, live and test. I have been asked to copy the data from the live system and put it into test. They are SQL Management Studio 2008 running on MS Server 2008R2.
Could a simple backup of the database, then copy that file to the test system and restore the database from that point work or it there more to it?
Express SMO Restore Only If Change System Date
Jun 23, 2012I am using the (SQL Express ) bellow given code to restore data from *.bak file (A backup file creater earlier by SQL backup). Some times this do not restore the data and gives error "Restore Failed". But when I change the system date to next day date then it restore data successfully.VB code used is as follow:
Dim strFileName As String
Dim rstDb As New Restore
Dim srv As Server
srv = New Server("(local)SQLEXPRESS")
Dim db As Database
db = srv.Databases("mydatabase")
[code]...
Operating System Error 1784 On DB Restore
Apr 11, 2007Hi there. Could someone help me out.
I'm performing a log restore and getting the following error within the SQL Server Error Log.
During restore restart, an I/O error occurred on checkpoint file 'G:MSSQL.1MSSQLBackupdxsh.CKP' (operating system error 1784(error not found)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
IT's a very basic Restore command and i do have not specified it to Restart.
Having checked the MS website for 1784 it suggests the following:
The supplied user buffer is not valid for the requested operation
Can anyone tell me what is wrong here and why it is creating a checkpoint file or even what it is and how to overcome the error message.
TIA
Installing Windows Defender After A System Restore
Feb 6, 2008I was running Windows Defender regularly as an add-on to the software supplied with my Sony laptop (2003). Then I had to execute a backdated System Restore to eradicate a recurring display omission on the Windows hardware screens and I lost the Defender program. I have now tried to start using Defender again. It downloads but won't run - errmess states it needs W Installer 3.1. I have downloaded the Windows.exe file for the Installer, but this has not made any difference. I cannot run Defender.
Anyone with any ideas ? Please keep it simple - I'm not a programmer !
Restore SMK And System Databases (credentials And Linked Servers)
Apr 28, 2008Hi there
I have a concern about restore whole SQL server environment.
1st server:
x86 SQL Server 2005 EE SP2 + hotfix 3159 is installed on Windows 2003 SP1 R2. SQL Server is running under Local System Account. Server is not part of AD.
2nd server
Win XP SP2, x86 SQL Server 2005 DE SP2 + hotfix 3159. SQL Server is running under Local Admin Account. Server is part of AD. Server has Credentials and linked servers
I'm trying to move all databases from server 2 to server 1
For this I am doing:
1) Create backup SMK
2) Detach all user databases
3) Backup all system databases
4) Copy all this stuff to server 1
5) Run Server 1 in single-mode (-m)
6) Restore master database
7) Try to restore backup SMK that was done on step 1 and get this error message:
Msg 15329, Level 16, State 11, Line 2
The current master key cannot be decrypted. If this is a database master key, you should attempt to open it in the session before performing this operation. The FORCE option can be used to ignore this error and continue the operation but the data encrypted by the old master key will be lost.
My understanding is that credential secrets, linked server login passwords are lost and should be recreated. DbMK can be restored using passwords.
As far as I know this can be avoided if the same domain account is using for both servers. But the question still this - if I have stand alone server, using local system account for the SQL Server service and have encrypted objects - I cannot restore SQL Server on another box (say in case disaster lost original one) without loosing credentials and linked servers even if I have all backups including backup of SMK.
Sounds gloomily for me. Any idea what I missed?
PS This links
http://blogs.msdn.com/lcris/archive/2005/09/23/473464.aspx
http://blogs.msdn.com/lcris/archive/2005/07/08/437048.aspx
http://blogs.msdn.com/lcris/archive/2005/09/30/475822.aspx
http://blogs.msdn.com/lcris/archive/2006/04/10/572678.aspx
and all relative topics in BOL were studied very carefully
Regards,
Gennadi
Backup Restore - System Hangs When Changing Media (DVD)
Mar 15, 2008
My Vista system hangs immediately after I insert the second blank DVD. I'm doing a simple backup of my user files. I'm using Vista Premium, fully up to date with patches, minimal software installed because this system is 100% used as a Media Center. Hardware is off the shelf HP Media Center m8067n.
I checked Microsoft knowledgebase and no other similar cases popped up. Is anyone else experiencing this?
Restore Backup To Second System Without Overwriting Local Custom Views?
Apr 25, 2008Is this possible?
here is the situation. I have a DB on one system. I back it up and then restore it to a second system. This second system I run reports off of and I want to create custom views that do not exist on the original system. Can I restore the
backup DB from the remote system without wiping out the custom views on the local system?
I have to do this this way as they won't let us create the views we want on the remote system so the only way we have access to run the reports is by restoring the backup locally.
TIA!
Update To Sp3a
Jan 23, 2004I'm trying to upgrade my MSDE to sp3a, I'm following the instructions.
c:sql2ksp3MSDE
setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=1
But receive the following message:
Invalid product code was found. Check if product is installed.
Then
Could not find package to install on the installation media.
Any help?
Thank you.
Sql 2000 Sp3a
Aug 5, 2003Select @@version does not know the difference between SP3 and SP3A.
Does anyone know of a SQL statement that will let me know if I have SP3A??
Thanks.
Cannot Get SP3a To Install
Jun 24, 2004We have the rtm version of SQL 2000 and have spent the last 2.5 hours trying to apply SP3a. Nothing on the microsoft support site has pointed us to the solution.
Basically, we start the install after shutting down the services, answer all the questions and then when it starts to copy files it fails with an error
'microsoft data access component failed (-1).
Looking in c:winntdatestup.log, the error is unknown. The c:winntsqlsrp.log file is not touched.
We tried renaming the odbcconf.dll file per a microsoft article and no joy.
We also restored mdac_type.exe file per microsoft article and no joy.
Trying to install SP1 and SP2 - same results.
Anyone got any ideas besides it's time to call Microsoft?
:confused:
Sp3a Does Not Seem To Apply
Feb 26, 2004I am trying to install sql server sp3a. I checked the version before and after the sp is applied, and it shows:
8.00.194
Now, according to the sp3a readme:
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp
the following versions should show:
SQL Server 2000 Original Release 8.00.194 RTM
Database Components SP1 or Desktop Engine SP1 8.00.384 SP1
Database Components SP2 or Desktop Engine SP2 8.00.534 SP2
Database Components SP3 or SP3a, or Desktop Engine SP3 or SP3a 8.00.760 SP3
This would imply that after installing sp3a and restarting, the version reported should now be 8.00.760. However, it still shows 8.00.194. So it appears to have not really installed, althought the sp3a installation ran without incident. So, how can I get the sp3a to not just act like it installed, but actually get it to install? Also, I have shut down all mssql services and rebooted, applied patch, and rebooted again. Doesn't help.
Also, if it is really installing, is there another way to tell?
Anyway, I really need to be able to install sp3a to see if it fixes another problem I'm having. Unfortunetly, since I can't even tell if the sp3a is installing, I can't tell if it really doesn't help or not. Thanks.
Tony F
SP3a Installs SP1
Oct 20, 2005I really don't understand this, in an attempt to upgrade/install SP3a, I download the file sql2kdesksp3.exe, which from the documentation, you can either use for upgrading or new installs. I run a new install; in the new instance, I execute "select @@version" and get "Service Pack 1"??
View 8 Replies View RelatedSQL 2000 SP3a To SP4
Apr 30, 2008
Our environment is currently running on SQL 2000 sp3a (win2003) and I'm having an issue with 'max worker threads', so I opened a ticket with Microsoft.
They tell me that SP3a is no longer support and I have to upgrade all our servers to SP4.
We had an issue in my previous company and I was told by a consultant that I shouldn't install SP4 because it caused a lot of issues. I'm aware of the 'AWE enabled' issue, are there any others I should watch out for?
Thanks
SQL Server 2000 SP3a
Sep 16, 2004Hi, I've downloaded the SP3a for sql server from the microsoft website. I unpackaged the files into a folder and ran the file setup.bat. I recieved an error that setupsql.exe file was not found. I think theres a folder missing called Setup under the X86 folder. Is there a way I can fix this????????
View 1 Replies View RelatedError On Sp3a URGENT HELP !!
Jul 9, 2004After past MDAC it fails running 1st script with error sp3_serv_uni.SQL(1) PLEASE HELP
View 2 Replies View RelatedSP3a Support And MSDE
Aug 21, 2007Hi
Now that support for SQL SP3a has been removed, how does this affect MSDE installations? We've got lots of products installed that have come with MSDE backends, all on SP3a. Is it up to the individual vendors as to whether they continue to support on this version? Backup Exec and Insight Manager are 2 that spring to mind.
thanks
Upgrade MSDE With SP3a With SP4
Jun 1, 2006Hi,
I'm trying to upgrade MSDE with SP4.
I used the following in command prompt.
setup /upgradesp sqlrun INSTANCENAME=MSDEINSTANCE SECURITYMODE=SQL UPGRADEUSER=username UPGRADEPWD=userpassword /L*v C:MSDELog.log
i got the message "Please go the control panel to install and configure system components."
What does it mean?
How to upgrade it?I have tried to edit the line with *V, and using the sa username and password, but i get the same message.
RegardsKenneth Davidsen
Does The MSDE2000 Sp3a Come With Northwind Database
Jan 30, 2004I just downloaded and installed MSDE2000 sp3a for winform and asp.net
quickstart tutorial. But I found it has no sample database such as pubs
and northwind. It used to have these databases. At least in last September
when .Net web Matrix came out.
If this is the case, can someone tell me where to get the sql scripts
to create Northwind database in MSDE?
Becasue the winform tutorial uses this database.
Thanks in advance!
Lei Xu
MSDE SP3a Upgrade Problem
Jun 14, 2004I just upgraded my desktop engine MSDE 1.0 to MSDE 2000 SP3a. Everything seemed to go well, MSSQLSERVER AND SQLSERVER Agent Services are running, problem is, I can no longer see the particular instance on the network from Enterprise Manager.
The installation instructions specified that if the Instance was to accept connections from applications on other computers not to specify the DISABLENETWORKPROTOCOLS parameter, so I didn't.
I'm a little green with this, can anyone suggest a place to start troubleshooting?
SP3a And Strong Password Problem
Jul 23, 2005I urgently need tom use SP3a upgrade the instance of SQLServer200MSDE runing on my local machine but I am having problems in doing so.My first problem is that when I start the set up procedure I get themessage"A strong SA password is required for security reasons. Please useSAPWD switch to supply the same"Currently the sa password isAbc/def/ghk1Which I think is a 'strong password' according to the microsoft rulesathttp://www.microsoft.com/resources/...sword_tips.mspxI would be grateful if someone could confirm that Abc/def/ghk1 is astrong password.If anyone could point me to some published informal help on installingSP3a then that would also be very helpful (I do of course have the MSread me file). If anyone has a sample command line entry for theupdating then I would find that extremely useful. There is oneinstance of MSDE on my machine, named NetSDK.Best wishes, John Morgan
View 6 Replies View RelatedSQL Fails After SP3a Has Been Applied. Slammer?
Jul 23, 2005A Win2k, SQL2k machine with SP2 that only just now has been updated to SP3afails in different ways. Among other things, when I now start EnterpriseManager, I get a message saying "rebbrui.rll" is missing and the snap-infails to initiate. But then the Manager starts anyway.But the SQL application does not work. I searched around the net, and Ifound that it looks as if SQL Slammer has been on the server. I can tell bythe similar symptoms other users have had, allthough I am not sure. Anyway,when I run some online virusscans and the Symantec SQLexp-tool to removeSlammer, I am told that the system is virusfree. Is that because SP3a toSQL2000 automatically got rid of the virus (if any)?But how do I get the SQL to run without any errors again?The server also runs in Terminal Application Mode.Regards, Lars.
View 4 Replies View RelatedSP3a Installation- Cannot Find Setupsql.exe
Jul 20, 2005current config: Windows XP SP1, SQL Server 2000trying to install : SP3a on SQL Server 20001. I downloaded the three files of the service pack from(http://www.microsoft.com/downloads/...&displaylang=en)..2. Saved the three files to a same local directory d:sqlsvr3a.3. Click through each and extracted them to same local directoryd:sql2ksp33. when I try to run the d:sql2ksp3setup.bat, it tells me thatx86setupsetupsql.exe is not found. Indeed, the file is not there inthe extracted folders.Is this a common problem, or am I missing something ?-thanks
View 1 Replies View RelatedSP3a + Extended Procedures = Not Nice (help!)
Jul 20, 2005Hi(sorry this has turned into a bit of an epic...thought I'd as theexperts!)SQL 2k, sp3a. Dual xeon 2.4. 2 gig ram. everything on a 3 disk raid 5.Microsoft SQL Server 2000 - 8.00.760 (Intel X86)Enterprise Edition on Windows NT 5.0 (Build 2195: )Problem seems to be some extended procs that seemed to be running fineon a 'vanilla' install on a different server now seem to be failing.Failures occuring c 6 - 10 hours.Sometimes the failure logs as the xp failure with severity 20 that Ikindof expect :s. other times absolutely nothing is logged.There are a variety of error messages - or sometimes nothing at all.http://www.mapinfo.com/common/docs/.../SWMSS48_RN.pdfdescribes one of our issues, which seems to come out on the restartafter a failure:Error event id is 19011, Message "SuperSocket info:ConnectionListen(Shared-Memory (LPC)) : Error 5."That site suggests:[color=blue]>Workaround>Suggested solutions include:>• Obtain a hotfix from Microsoft (http://www.microsoft.com). You will[/color]need to >cite the 94302[color=blue]>reference number.>• Turn off shared memory in the client network configuration utility[/color]to >disable shared[color=blue]>memory.>• Replace the SQL Server SSMSLPCN.DLL with the SSMSLPCN.DLL[/color](8.00.540) from >SQL[color=blue]>Server 2000 Service Pack 2.[/color]- but I cant find any sensible information which describes this tocorrelate! Searching MS for that number (94302) came up with zip.The dll version we are running is 2000.80.760.0, although earlierversions are elsewhere on the server (disk images).Interesting to note that we seem to be able to replicate the 'leakage'of improperly closed handles on this version, but not on the oldserver runningthat dll version 2000.80.194.0. This I understood to have been fixedin sp3.On one failure we caught the following (involving our extended procs):2004-02-15 15:03:31.40 spid58 Error: 0, Severity: 20, State: 02004-02-15 15:03:31.40 spid58 Stored function'xp_Contest_CalculateScores' in the library 'e:sqlxpga_procs.dll'generated an access violation. SQL Server is terminating process 58..2004-02-15 15:04:32.14 spid64 Error: 0, Severity: 20, State: 02004-02-15 15:04:32.14 spid64 Stored function 'xp_XML_GetSubTree'in the library 'e:sqlxpga_procs.dll' generated an access violation.SQL Server is terminating process 64..2004-02-15 15:04:48.48 spid53 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 53, PSS = 0x472d7200, EC = 0x725fc098*Stack Dump being sent to e:sqlMSSQLlogSQLDump0001.txt* ************************************************** ******************************* BEGIN STACK DUMP:* 02/15/04 15:04:48 spid 53This was followed about a minute later by:2004-02-15 15:04:55.75 spid53 Stack Signature for the dump is0x1CC032652004-02-15 15:04:55.75 spid53 SQL Server Assertion: File:<recbase.cpp>, line=1378Failed Assertion = 'm_offBeginVar < m_SizeRec'.2004-02-15 15:04:55.89 spid53 Using 'dbghelp.dll' version '4.0.5'*Stack Dump being sent to e:sqlMSSQLlogSQLDump0002.txt2004-02-15 15:04:56.01 spid53 SqlDumpExceptionHandler: Process 2292generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQLServer is terminating this process.* ************************************************** ******************************* BEGIN STACK DUMP:* 02/15/04 15:04:55 spid 53As a side issue we have a number of 'initialisation of notify failed'notes.Any one have any clue about this?Might the DLL need rolling back?Is sp3a knacked for extended procs?Is there some daft setting I've missed :/Any good events to track in particular?Cheers all!
View 1 Replies View RelatedDTS Import Not Working After SP3a Upgrade
Jul 20, 2005I have a DTS package that is importing a fixed length file.After installing SP3a (on PERSONAL & DEVELOPER edition) it will notallow me to assign more than 125 fixed length column positions.After hitting the Finish & OK button it just wipes out the columnsettings.I've reinstalled both Personal & Developer edition. DTS will allowmore than 125 prior to the service pack.
View 2 Replies View RelatedInstalling SQL Server 2000 SP3a
Jul 9, 2007I got this message from
Backup Exec for Windows Servers Environment Check 1.0 for SBS1
QUOTE
An instance of Microsoft SQL 2000 was found that is not updated to Service Pack 3a.
An instance of Microsoft SQL Server was found that is not updated to the correct service pack. Using this SQL Server instance with Backup Exec may cause errors. To install Backup Exec successfully, upgrade this SQL Server to Service Pack 3a, or select another instance.
Instance: SBSMONITORING, Version: 2000 SP 3a
Instance: SHAREPOINT, Version: 2000 SP 3a
Instance: BKUPEXEC, Version: 2000 SP 3a
Instance: PADMINISTRATOR, Version: 2000 SP 3a
Instance: MICROSOFT##SSEE, Version: 2000
UNQUOTE
My Question is how to upgrade the instance : "MICROSOFT##SSEE, Version: 2000" to SP 3a?
Failed To Upgrade MSDE2000 SP3a To SP4
Aug 24, 2006Hi,
Recently when i try to upgrade my current MSDE 2000 (SP3a) to SP4, the system just keep on failing me. Here is the scenario:
1. Download the MSDE2000 SP4 from microsoft
2. Extract the SP4
3. Run the following command in either the command prompt or via a batch file:
echo off
echo "Start to Upgrade MSDE SP4 ... "
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=Th3B3st /L*v c:MSDE_Log.log
echo "SP4 Upgrade Process completed!"
4. Once the above batch file was runned, the standard SQL configuration screen (gathering information) will be triggered.
5. However after a while the installation will just stopped.
6. When i checked on the log, i have found out that the failure of installation is due to the system has failed to configure the server. PFB for the last few rows of the verbose log:
=== Logging stopped: 8/22/2006 17:36:49 ===
MSI (c) (90:88) [17:36:49:865]: Note: 1: 1729
MSI (c) (90:88) [17:36:49:865]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
MSI (c) (90:88) [17:36:49:865]: Grabbed execution mutex.
MSI (c) (90:88) [17:36:49:865]: Cleaning up uninstalled install packages, if any exist
MSI (c) (90:88) [17:36:49:865]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/22/2006 17:36:49 ===
7. When i check the MSI Installer Event ID at Microsoft site, it just said that this is the server configuration problem and i cant find any solution.
Any forumers here experience the above before? Mind to share some thoughts?
FYI, my current MSDE configuration is as follow:
- MSDE 2000 Release A (SP3a - 8.00.760)
- Installed Instance = JSNG
Thanks.
regards,
JS