Hi Everyone,
We have an Analysis Services database which has 9 cubes. Whenever I do an Archive/Restore it fails giving the following error:
* Unexpected error encountered while updating repository item cannot be found in the collection corresponding to the requested name or ordinal.
* Restoration Cancelled
* DSO function failed
Please advise.
Regards,
Kalyan
I'm trying to figure out why this SQL Agent job keeps failing.
We used management studio, and connected as mydomainmyuser, and developed a script to take a backup file from a network share and restore it. It worked fine in SSMS under that login.
After we got it working , we created a SQL Agent job on the same server to run the script, and set the agent job to run under that account that we tested with.
This is the error message we got:
"Executed as user: mydomainmyuser. Create Database permission denied in database master'.
So, I gave that login the rights to Create Database and Create Any Database. Then the error message changed to:
"Executed as user: mydomainmyuser. User does not have permission to RESTORE database 'mydatabase'. [SQLSTATE 42000][ERROR 3013] RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. "
* I can't use SA for the job account, because the SA account doesn't have rights to see the network folder where the backup file sits, so it has to run under the domain account.
* The user is a member of the dbcreator role - and the serveradmin and sysadmin roles
* The user is a member of dbowner on the database I am trying to overwrite with the restore
* I have given the user the rights CREATE DATABASE and CREATE ANY DATABASE
The only suspicious thing I found was that it appears the server was renamed at one time. When I looked at the login in management studio, I was not able to change some of the rights. On the Securables page, it shows the server name as "MyServer-New", but the server name is "MyServer". It is a replacement, and I suspect that when they did the replacement they named it "MyServer-New", set everything up, then renamed it.
I found this post listed below, and ran the script (shown below), and it showed that the server name was MyServer and the ServerInstanceName is MyServer-New
[URL] .....
SELECT HOST_NAME() AS 'host_name()',
@@servername AS 'ServerNameInstanceName',
SERVERPROPERTY('servername') AS 'ServerName',
SERVERPROPERTY('machinename') AS 'Windows_Name',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name',
SERVERPROPERTY('instanceName') AS 'InstanceName',
SERVERPROPERTY('IsClustered') AS 'IsClustered'
I can't reset SQL until the next maintenance window to test changing the server name as outlined in the post.
Am I on the right track with the name change messing up permissions, or is there something else I need to check?
I'm performing an upgrade of a DW Warehouse Server from SQL Server 2008 to another machine with SQL Server 2014.I know that you can perform the restore via the SSMS GUI but I want to script it out.URL....
View 4 Replies View RelatedIf I have a database backup from sunday, and a failure occurs monday... Can the backup .mdf and .ldf files be attached, and the backup log after the point of failure be applied to them?
The problem I am having is it looks like you can only restore from a .bak file, and then apply the log at the point of failure. IT doesn't look like you can restore the .ldf/.mdf files, and then apply the backup log from the point of failure.
Can someone please help? I'm in desparate need of fixing this !
Thanks,dp
We have received a backup of a database from an external company for a project that we are taking over. We have attempted to restore the database and it fails giving us the error: "Internal consistency error occurred."
We have run the restore verifyonly command with the results: "The backup set is valid." However, I don't have confidence that the verify is telling the complete story.
It appears that the database is restored and the overall restore is failing on the transaction log file.
Any help is appreciated. This is rather urgent.
Hi,
I have a SQL Server 2005 Database that I would like to export to SQL Server Express.
How do I go about this?
I've tried backing it up, creating a new (blank) SQL Server Express Database and trying to restore it, but get the following message
------------------------------
Restore failed for Server 'PRODSOL-LAPTOP1SQLEXPRESS'. (Microsoft.SqlServer.Smo).
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'test' database. (Microsoft.SqlServer.Smo)
please help
Regrds
T.Anantha Krishnan
I restored a DB to another server and then i used the stored procedures
exec sp_addlogin on the master DB and the exec sp_change_users_login on the DB that I have restored. When i try to run a sproc I am getting
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
I have used windows authentication to login to connect to the server using sql management studio
Am i missing something. Thankyou for the help
Try to restore a disk backup from serverA to serverB, get following error:
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'backup_ABC_Database' is not a valid Microsoft Tape Format backup set.
But there is no Tape Format at all,
attached is the return info of this backup file
Restore headeronly from backup_ABC_database
-----------------------------------
the database is in "Loading" status with gray shadow....
-D
I am trying to connect Sharepoint 2013 services (performancepoint , excel services) to SSAS 2012 using the EffectiveUserName.
I was getting a error message regarding conencting the datasource and when checking profiler it was saying Logon failure: unknown user name or bad password.
On the SSAS server i tried using EffectiveUserName in the additional Connection Parameters and it failed for the above reason. I also tried my username as well as the sharepoint service accountthe sharepoint service account and my username are both server admins.
When I try using the EffectiveUserName in the additional Connection Parameters on another server I can connect with no problems.
What seems to be the different with server where I am getting the error message?
hi,
My requirement is as follows:
1. I Dump my Database into a dump device
2. I Rebuild my mater Database
3. I Restore my User Database.
4. At the end of the above exercise I find my relationship between sysusers (User Database) and syslogins (master) is totally screwed up. This has been causing logon problems to my User Database…
5. I tried using sp_change_users_login …but it does not seem to work.
Thanking you in advance for your help rendered
Hallo
I have a bit of a problem I haven't come across before. I was testing some restore code using smo, when the restore process got corrupted. Now I cannot log into that database file. Whenever I try and connect to it, I get a login error. Connections to this database file previoulsy worked very well.
I do not get login errors for databases with different names, or when using the same database file on another computer. There must be some data stored somewhere that is causing this. I have removed the database file and reloaded it, but to no avail. Any insight into this would be appreciated
Hi,
I was trying to upgrade SQL server 2005 to SP1, to be able to install Team Foundation Server.
However, I get a failure at the Database Services part. It sends an error report to Microsoft.
Any help would be very much appreciated...
Here's the logging: http://www.invenso.com/Logs.zip
And these are the basic errors:
01/25/2007 13:00:07.234 ================================================================================
01/25/2007 13:00:07.250 Hotfix package launched
01/25/2007 13:00:08.437 Product discovery successfully completed during the install process for MSSQLSERVER
01/25/2007 13:00:08.437 SP Level check successfully completed during the install process for MSSQLSERVER
01/25/2007 13:00:08.453 Product language check successfully completed during the install process for MSSQLSERVER
01/25/2007 13:00:08.468 Product version check successfully completed during the install process for MSSQLSERVER
01/25/2007 13:00:08.484 Command-line instance name check completed during the install process
01/25/2007 13:00:08.484 Baseline build check completed during the install process
01/25/2007 13:00:44.125 Attempting to install instance: MSSQLSERVER
01/25/2007 13:00:44.140 Attempting to install target: PESERVER1
01/25/2007 13:00:44.187 Attempting to stop service: MSSQLServer
01/25/2007 13:00:48.203 Successfully stopped service: MSSQLServer
01/25/2007 13:00:48.203 Attempting to check for locked files: sqlrun_sql.msp
01/25/2007 13:00:48.296 Attempting to check for locked files: \PESERVER1c$7df9321a724c583a5f25c26f2a35HotFixSQLFilessqlrun_sql.msp
01/25/2007 13:00:48.312 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.out
01/25/2007 13:01:06.859 MSP returned 1602: The user cancels installation.
01/25/2007 13:01:06.921 Successfully checked file: \PESERVER1c$7df9321a724c583a5f25c26f2a35HotFixSQLFilessqlrun_sql.msp
01/25/2007 13:01:06.953 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
01/25/2007 13:01:06.968 Failed to read registry key: PendingFileRenameOperations
01/25/2007 13:01:07.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll
01/25/2007 13:01:07.015 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll
01/25/2007 13:01:07.031 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll
01/25/2007 13:01:07.046 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll
01/25/2007 13:01:07.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll
01/25/2007 13:01:07.078 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll
01/25/2007 13:01:07.078 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe
01/25/2007 13:01:07.093 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll
01/25/2007 13:01:07.109 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe
01/25/2007 13:01:07.125 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll
01/25/2007 13:01:07.140 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll
01/25/2007 13:01:07.156 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll
01/25/2007 13:01:07.156 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll
01/25/2007 13:01:07.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll
01/25/2007 13:01:07.187 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL
01/25/2007 13:01:07.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll
01/25/2007 13:01:07.203 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll
01/25/2007 13:01:07.218 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplrec.dll
01/25/2007 13:01:07.218 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
plisapi.dll
01/25/2007 13:01:07.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:WINDOWSassemblyGAC_32Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll
01/25/2007 13:01:07.250 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
01/25/2007 13:01:07.250 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
plhtfin.sql
01/25/2007 13:01:07.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe
01/25/2007 13:01:07.281 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMsnapshot.exe
01/25/2007 13:01:07.281 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplmerg.exe
01/25/2007 13:01:07.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90COM ablediff.exe
01/25/2007 13:01:07.296 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe
01/25/2007 13:01:07.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe
01/25/2007 13:01:07.328 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll
01/25/2007 13:01:07.343 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10422005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1041sqlevn70.rll
01/25/2007 13:01:07.359 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10402005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1036sqlevn70.rll
01/25/2007 13:01:07.375 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1031sqlevn70.rll
01/25/2007 13:01:07.390 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10282005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033XPStar90.RLL
01/25/2007 13:01:07.406 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
01/25/2007 13:01:07.406 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
01/25/2007 13:01:07.421 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
01/25/2007 13:01:07.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn6.6.3.5
C:Program FilesMicrosoft SQL Server90Sharedmsxmlsql.dll
01/25/2007 13:01:07.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrw.dll
01/25/2007 13:01:07.437 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
01/25/2007 13:01:07.453 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
01/25/2007 13:01:07.468 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
01/25/2007 13:01:07.500 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll
01/25/2007 13:01:07.546 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll
01/25/2007 13:01:07.609 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll
01/25/2007 13:01:07.625 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
01/25/2007 13:01:07.625 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
01/25/2007 13:01:07.640 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
01/25/2007 13:01:07.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
01/25/2007 13:01:07.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
01/25/2007 13:01:07.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
01/25/2007 13:01:07.671 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
01/25/2007 13:01:07.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
01/25/2007 13:01:07.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
01/25/2007 13:01:07.703 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
01/25/2007 13:01:07.703 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
01/25/2007 13:01:07.718 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
01/25/2007 13:01:07.734 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90SharedResources10339.0.2047.0
C:Program FilesMicrosoft SQL Server90Sharedmsmdrdir.dll
01/25/2007 13:01:07.750 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0
C:Program FilesCommon FilesSystemole dbxmlrw.dll
01/25/2007 13:01:07.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
01/25/2007 13:01:07.781 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
01/25/2007 13:01:07.781 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
01/25/2007 13:01:07.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
01/25/2007 13:01:07.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
01/25/2007 13:01:07.828 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
01/25/2007 13:01:07.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
01/25/2007 13:01:07.859 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
01/25/2007 13:01:07.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
01/25/2007 13:01:07.890 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
01/25/2007 13:01:07.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
01/25/2007 13:01:07.906 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
01/25/2007 13:01:07.921 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033
C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml
01/25/2007 13:01:07.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
01/25/2007 13:01:07.953 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
01/25/2007 13:01:07.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
01/25/2007 13:01:07.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
01/25/2007 13:01:07.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
01/25/2007 13:01:08.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
01/25/2007 13:01:08.015 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
01/25/2007 13:01:08.031 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
01/25/2007 13:01:08.046 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
01/25/2007 13:01:08.062 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
01/25/2007 13:01:08.062 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0
C:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe
01/25/2007 13:01:08.093 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsvc~1.dll
01/25/2007 13:01:08.093 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
01/25/2007 13:01:08.109 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
01/25/2007 13:01:08.125 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
01/25/2007 13:01:08.140 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
01/25/2007 13:01:08.156 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
01/25/2007 13:01:08.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
01/25/2007 13:01:08.187 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
01/25/2007 13:01:08.187 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
01/25/2007 13:01:08.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
01/25/2007 13:01:08.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
01/25/2007 13:01:08.234 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
01/25/2007 13:01:08.250 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
01/25/2007 13:01:08.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe
01/25/2007 13:01:08.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0
C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll
01/25/2007 13:01:08.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
01/25/2007 13:01:08.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
01/25/2007 13:01:08.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
01/25/2007 13:01:08.328 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll
01/25/2007 13:01:08.343 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
01/25/2007 13:01:08.359 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
01/25/2007 13:01:08.375 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll
01/25/2007 13:01:08.390 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
01/25/2007 13:01:08.406 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
01/25/2007 13:01:08.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
01/25/2007 13:01:08.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll
01/25/2007 13:01:08.437 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll
01/25/2007 13:01:08.453 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
01/25/2007 13:01:08.484 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
01/25/2007 13:01:08.500 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
01/25/2007 13:01:08.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe
01/25/2007 13:01:08.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
01/25/2007 13:01:08.593 Attempting to install file: sqlrun_sql.msp
01/25/2007 13:01:08.640 Attempting to install file: \PESERVER1c$7df9321a724c583a5f25c26f2a35HotFixSQLFilessqlrun_sql.msp
01/25/2007 13:01:08.656 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log
01/25/2007 13:01:08.671 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
01/25/2007 13:01:08.687 Failed to read registry key: Debug
01/25/2007 13:02:47.859 MSP returned 1603: A fatal error occurred during installation.
01/25/2007 13:02:47.937 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
01/25/2007 13:02:47.953 Failed to read registry key: Debug
01/25/2007 13:02:47.968 Unable to install MSP file: \PESERVER1c$7df9321a724c583a5f25c26f2a35HotFixSQLFilessqlrun_sql.msp
01/25/2007 13:02:47.984 The following exception occurred: Unable to install Windows Installer MSP file Date: 01/25/2007 13:02:47.984 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856
01/25/2007 13:02:48.078
01/25/2007 13:02:48.093 Product Status Summary:
01/25/2007 13:02:48.109 Product: SQL Server Native Client
01/25/2007 13:02:48.125 SQL Server Native Client (RTM ) - Success
01/25/2007 13:02:48.187
01/25/2007 13:02:48.203 Product: Setup Support Files
01/25/2007 13:02:48.218 Setup Support Files (RTM ) - Success
01/25/2007 13:02:48.234
01/25/2007 13:02:48.265 Product: Database Services
01/25/2007 13:02:48.281 Database Services (RTM 1399 ENU) - Failure
01/25/2007 13:02:48.281 Details: Unable to install Windows Installer MSP file
01/25/2007 13:02:48.296 Analysis Services (SP1 2047 ENU) - Not Applied
01/25/2007 13:02:48.312 Reporting Services (SP1 2047 ENU) - Not Applied
01/25/2007 13:02:48.328
01/25/2007 13:02:48.328 Product: Notification Services
01/25/2007 13:02:48.343 Notification Services (SP1 2047 ENU) - Not Applied
01/25/2007 13:02:48.359
01/25/2007 13:02:48.375 Product: Integration Services
01/25/2007 13:02:48.375 Integration Services (SP1 2047 ENU) - Not Applied
01/25/2007 13:02:48.390
01/25/2007 13:02:48.406 Product: Client Components
01/25/2007 13:02:48.421 Client Components (SP1 2047 ENU) - Not Applied
01/25/2007 13:02:48.437
01/25/2007 13:02:48.453 Product: MSXML 6.0 Parser
01/25/2007 13:02:48.468 MSXML 6.0 Parser (RTM ) - Not Applied
01/25/2007 13:02:48.484
01/25/2007 13:02:48.500 Product: SQLXML4
01/25/2007 13:02:48.515 SQLXML4 (RTM ) - Not Applied
01/25/2007 13:02:48.515
01/25/2007 13:02:48.531 Product: Backward Compatibility
01/25/2007 13:02:48.531 Backward Compatibility (RTM ) - Not Applied
01/25/2007 13:02:48.546
01/25/2007 13:02:48.562 Product: Microsoft SQL Server VSS Writer
01/25/2007 13:02:48.578 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
01/25/2007 13:02:48.593
01/25/2007 13:11:46.921 Hotfix package closed
I am new to Analysis Services. Do I have to schedule backups for Analysis Services databases just like I do for SQL Server databases? or do I just need to backup the C:Program FilesMicrosoft analysis ServicesBinmsmdrep.mdb?? Please help. Thanks.
View 1 Replies View RelatedI am new to Analysis Services, do I have schedule Analysis Service database backup job just like I do for SQL Server databases? Or I just need to backup the C:Program FilesMicrosoft Analysis ServciesBinmsmdrep.mdb file. Thanks in advance.
View 6 Replies View RelatedHi,
I'm trying to get my first replication going, and I have set up a database successfully, along with merge replication, however when I attempt to create the first subscriber, I get a permissions issue, regardless of what I do. In the SQLCESA30.LOG file, I get the following entries:
2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627
I posted the initial thread under the "Replication" forum, but am including this 'pointer' post here due to a lack of replies there, and the relevance of this thread to this forum. Please see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for more details.
Thanks.
I do not understand why an SSAS cube disappears after a reboot. We schedule a reboot for our server weekly and after the reboot. I have to deploy my SQL server Analysis Database. It is just gone after a reboot and why this happened. I searched a lot on internet but it seams that I am the only one on this world with this issue.
How I can configure the server in such a way that the SSAS cubes will not disappear after a reboot.
Hi，I have a backup file in the database server,and I want to restore database using the backup in client.What should I do?
Thanks for any word.
i want to restore database in same server with another name, i already taken backup in d drive, and getting below error the backup set holds a backup of a database other than the existing database restore database is terminating abnormally(mssql server error:3152)
View 1 Replies View RelatedHello All!
I would like you to help me with syntax to restore the database
Here is my situation I haver ServerA and ServerB. ServerA has DB called TEST and is being backed up everyday on D:Program FilesMicrosoft SQL ServerMSSQLBACKUPTest.Bak, now I need to restore this backup on ServerB's D-drive. Help me with the T-SQL syntax.
A client sent me a full database backup (SQL Server 2005 Express). How can I restore that database to my SQL Server 2005 Express?
I've tried this...
RESTORE DATABASE JensenMorganLinen
FROM DISK = 'C:JensenMorganSQL.bak'
WITH NORECOVERY,
MOVE 'Jensenmorganlinen_Data' TO
'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataJensenMorganLinen.mdf',
MOVE 'Jensenmorganlinen_Log'
TO 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataJensenMorganLinen.ldf'
But the results is this...
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'JensenMorganLinen' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Hi, i am using sql server 2000, and i make daily backups. I want torestore my backup to a test msde database i have. I don't know how idid it last time.-The database name is the same: "web" on both places-The database is located on different hard drives and the file nameare different on both places.I tried to do it from enterprise manager, restore database, fromdevice, i chose the transaction file and the database backup itselfand tried to restore, but i got an error that i don't have exclusiveaccess to the database.How can i fix this?
View 5 Replies View Related
Hello, I have a question related to SQL Server DB Restore scenario:
1. I have taken full, log backup from the old servers and restore in New server. (This is where my old system crashed, I installed SQL Server in a new environement)
Can I restore old environment Master, MSDB to new environment Matser, MSDB? How it works?
2. Is there any better way to have Master image on new environment? How we can update registry values in Windows 2003 environement? How we can clone any thing, if that person is brain dead (coma) like in OS Clone?
please advise.
Thanks, Jay
I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions. When configuring the Power BI analysis services connector, at the point where you enter Friendly Name, Description and Friendly error message, when you click next I receive the error "The remote server returned an error (403)." I've tested connecting to the database from Excel on a desktop and connect fine.I don't use a "onmicrosoft" account so don't have that problem to deal with.
We use Power BI Pro with our Office 365. As far as I can tell that part is working ok as I pass that stage of the configuration with a message saying connected to Power BI.The connector is installed on the same server as tabular services, its a Win2012 Standard server. The tabular instance is running a domain account that is the admin account for the instance (this is a dev environment) that account is what I've used in the connector configuration. It's also a local admin account. There is no gateway installed on the server.
I need to back up a production database on one server and then copy it to a test server wherel it will be restored. The problem is that I don't know where to move the file to on the production server before I restore it. Is there a special folder I need to copy the file to? I see a folder named ProgramFilesMicrosoft SQL Server but beyond that I have no idea where to copy the file so that it can be restored?
Can someone help me out please?
Hi,
Any one know how to restore a SQL 2000 backup on to a server which has SQL 7.0??
Thanks,
Naveen
I want to backup an SQL Server database through a client application written in VB 6.0, and not through the Enterprize Manager.
I use the SQLDMO Objects Library to backup the database to the SQL Server machine through my application,
but there are the following problems:
a. The backup can be done only locally to the SQL Server machine. Is there any way to bypass this restriction?
b. To get the Directories Structure of this machine i use the xp_FixedDrives, xp_Subdirs stored procedures.
That's ok for the Backup operation but i do not have a way to view the FILES to perform Restore operation.
Of cource VB function Dir() cannot be used to view files on the server because of access restrictions.
Is there any workaround for that?
I have a .bak full database backup from a computer. Now I installed new SQL Server 2005 in another computer and would like to restore the .bak database here. How it can be done?
When I right click database and select restore database, it opens a window where it asks to put "destination for restore". This is a new SQL Server, how can I restore then?
Hi, i need help about restore a DB
I did a backup of a database using SQL Server Management Studio, but when i try to restore my database now, i get this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'Athenas'. (Microsoft.SqlServer.Smo)
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
What do i doing so bad??
Thanks for ur opinions and help.
Regards
------------------------------------------
JeanScrash
I am using SQL Server Management Studio 12 to try to restore a backup to a new database. I know I have done this before, but cannot seem to make it happen now. Her is what I have.
Backup file is "C:TempInProcessInspection_DataSQL_backup_2015_02_23_000012_4551393.bak"Â and it is for sure there.Â
This came from a customer of mine.I launch SQL Server Management Studio 12 and log in as SA. I right click on Databases and chose Restore Database. I choose Device then file then Add and try to browse the the named location.Â
When I get there, regardless if I choose All files or Bak, I see no files.I tried to upload an image of the "Upload Backup File" dialog, but MSDN would let it happen. When I get to the c:temp folder, no files appear in the window.
Hi All
I have Computer is setuped SQL Server 2000 and SQL server 2005 when I restore SQL Server 2005 it's OK but when it's not OK when I restore in SQL Server 2000. The Error as follows:
Please help me to solve this problem. Thanks
UAT environment : SQL Server 2008 R2 SP3 Enterprise Edition
SANDBOX environment : SQL Server 2008 R2 SP3 Standard Edition
I have a database backup (.bak) that was taken from UAT environment that has CDC enabled on some tables. I want to restore that database into my SANDBOX environment which does not support CDC (because of standard edition). The restore process fails due to this incompatibility. Is there any way to restore without CDC (I dont CDC enabled on my SANDBOX; just my data from the backup) ?
Hi All
This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out.
Thanks
Raoshan
I have seen this before. A 2000 restore fails, leaving the database thinking it is being restored but the restore job failed and errors when it is restarted. EM is clueless. I believe there is a proc to reset some flag. Can you share it with me???
Thanks!