Ms Sql 2000 Device Activation Error
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Device activation error. Device activation error. Rate Topic Display Mode Topic Options Author Message Arindam GangulyArindam Ganguly Posted Monday, October 3, 2005 7:18 AM Forum Newbie Group: General Forum Members Last Login: Monday, November 23, 2015 10:58 PM Points: 7, Visits: 231 Hi,I have setup a job for restoring full Backup ofa Production Database in my Test Server but end up in restoration Failed info even after 90% of restoration is completed with the following error Message :P41Production restoration job has failed again.It has failed after restoring 90% of database and giving following error :Executed as user: SHL-DC1-DOM2\SQLAdmin. ...000] (Error 5173) Device activation error. The physical file name 'D:\MYSQLData\MyProdn_1.MDF' may be incorrect. [SQLSTATE 42000] (Error 5105) Cannot associate files with different databases. [SQLSTATE 42000] (Error 5173) Log file 'D:\MYSQLLogs\MyProdn_log.LDF' does not match the primary file. It may be from a different database or the log may have been rebuilt previously. [SQLSTATE 01000] (Error 5108) 10 percent restored. [SQLSTATE 01000] (Error 3211) Associated statement is not prepared [SQLSTATE HY007] (Error 0) 20 percent restored. [SQLSTATE 01000] (Message 3211) 30 percent restored. [SQLSTATE 01000] (Message 3211) 40 percent restored. [SQLSTATE 01000] (Message 3211) 50 percent restored. [SQLSTATE 01000] (Message 3211) 60 percent restored. [SQLSTATE 01000] (Message 3211) 70 percent restored. [SQLSTATE 01000] (Message 3211) 80 percent restored. [SQLSTATE 01000] (Message 3211) 90 percent restored. [SQLSTATE 01000] (Mess... The step failed.As per having full right in my Local Drive location I am not being able to find any clue behind it. Can anyone help me in getting any solution for it.Thanks & Regards,Arindam Ganguly. Post #225466 Linda M PalladinoLinda M Palladino Posted Monday, October 3, 2005 8:03 AM SSC-Addicted Group: General Forum Members Last Login: Thursday, November 19, 2015 7:00 AM Points: 412, Visits: 25 Is the restore on the same server or are you restoring to a different server? If it's the same you probably need to rename the files and/or include the move or replace options. Post #225513 ajitanuajitanu Posted Thursday, November 22, 2007 12:09 AM Forum Newbie Group: General Forum Members Last Login: Thursday, November 22, 2007 12:00 AM Points: 2, Visits: 0 hi sir, i am in problem i am using sql 2000 with
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it http://www.sqlservercentral.com/Forums/Topic225466-5-1.aspx only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Server 2000 - Restoring .MDF Using sp_attach_single_file_db fails with error up vote 3 down vote favorite Because more than one person was meddling with the database, http://serverfault.com/questions/268403/sql-server-2000-restoring-mdf-using-sp-attach-single-file-db-fails-with-error we have lost our transaction log files and consequently lost the database. Luckily, we have the MDF file still perfectly intact, and we're not worried about the lost transactions, since they were only 'delete' transactions. I did some research, and found that the sp_attach_single_file_db command is pretty much meant for this, and the sql server was shutdown before the file was removed. I used this command: EXEC sp_attach_single_file_db @dbname = 'RecoveredDatabase', @PhysName = 'E:\SQL Data\AerationBasinsTrend_data.mdf' Where 'RecoveredDatabase' is my new database, and 'E:\SQL DATA\AerationBasinsTrend_Data.mdf' is the phyiscal .mdf file. I get an error when I run this. The server reports this: Server: Msg 1813, Level 16, State 2, Line 1 Could not open new database 'RecoveredDatabase'. CREATE DATABASE is aborted. Device activation error. The physical file name 'E:\SQL Data\AerationBasinsTrend_Log.LDF' may be incorrect. Device activation error. The physical file name 'C:\SQL Backup\TransLog' may be incorrect. As far as I know, this command should create a new ldf file if the old one is not present. What a
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking http://crm.ittoolbox.com/groups/technical-functional/saleslogix-l/device-activation-error-the-physical-file-name-may-be-incorrect-3804323 Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX VoIP_News Inside-ERP I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus ms sql Craig Borysowich Dennis Stevenson mircea_luca Richard DukeGanote iudithm Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk jakarman Adrian_Grigoriu knowscognosdoi COMPANIES GeoTrust Juniper Networks Silver Peak Sophos View All Topics View All Members View All Companies Toolbox for IT Topics CRM Groups Ask a New Question SalesLogix For discussion on SalesLogix , please visit the CRM ms sql 2000 – General Discussions group. More CRM Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Device activation error. The physical file name may be incorrect. twestfall asked Oct 7, 2010 | Replies (14) I have 2 users where when I try to install their remote databases I get an error. This is SalesLogix 6.2.3. Each time I attempt to do the install I get Device activation error. The physical file name 'C:\SLX_user_log.ldf' may be incorrect