Device Activation Error Sql Server
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Device activation error - while restoring database SQL Server > SQL Server activate sql server 2008 r2 evaluation High Availability and Disaster Recovery Question 0 Sign in to vote Hi all,I how to activate sql server authentication have taken a full database backup from a Server and I tried to restore it in another server. SQL
How To Activate Sql Server Agent
Server 2000 is installed in both of themThings I did1. The database is very huge(about 65GB), so I truncated the log by following http://support.microsoft.com/default.aspx/kb/2723182. Created a backup of the database, through UI with default
How To Activate Sql Server 2012
options3. Copied the .bak file to the new server and while restoring the backup I am getting the following error: Device activation error. The physical file name 'c:\dv1data3\dv1data3.ndf' may be incorrect.And in my eventlog, I find the following error:17204:FCB::Open failed: Could not open device c:\dv1data3\dv1data3.ndf for virtual device number(VDN) 4The restoration process fails only after some 10-15 mins.Any help would be highly appreciated.Thanks,Jeevitha how to activate sql server 2012 standard Edited by Jeevitha - MSFT Wednesday, May 20, 2009 9:30 AM Adding some more info Wednesday, May 20, 2009 9:28 AM Reply | Quote Answers 0 Sign in to vote If you backup a database from SQL server A and then restore it to a database on SQL server B, probably the GUI can't help you with the restore process. You have to use the SQL command to do the restore. Because the original database, which may consists of several data files(.ndf, .mdf and .ldf files), requires that the SQL Server B has exact the same file locations. If any path on Server A doesn't exist on Server B it will give you an error. You can use FILELISTONLY to display how many files are included in the original backup. Then use MOVE TO to assign each of the database file to a new location on SQL Server B. Here is an example--View how many files are in the current database backupRESTORE FILELISTONLY FROM disk= 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Northwind.bak'--Assign each SQL Server file to a new location on Server BRESTORE database NorthwindFROM disk= 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Northwind.bak'with replace, move 'Northwind' to 'd:\Northwind.mdf',move 'Northwind_Log' to 'd:\N
ACTIVATION ERROR (SUSPECT DATABASE) Discussion in 'General DBA Questions' started by mackie01, Feb 23, 2008. mackie01 New Member I WAS TRYING TO CREATE A NEW
Activate Sql Server 2012 Trial
DATABASE ON SQL 2000 BUT I AM HAVING THIS PROBLEM/ ERROR ERROR 5105: how to activate sql server 2014 DEVICE ACTIVATION ERROR. THE PHYSICAL FILE NAME 'D:MUSERVERDBMUONLINE_DATA.MDF' MIGHT BE INCORRECT... WHY IS THAT???? I MEAN....I'VE BEEN TRYING TO CREATE device activation error sql server 2000 SO MANY TIMES....REBOT SO MANY TIMES BUT I STILL HAVE THE SAME PROBLEM. SOMETIMES, THE PROMPT EVEN TELLS ME THAT 'FILE IS UNACCESSABLE OR MAYBE NOT ENOUGH MEMORY SPACE. PLZ...I DO APPRECIATE IT https://social.msdn.microsoft.com/Forums/sqlserver/en-US/965cc829-b972-430b-97cc-b4133db242ba/device-activation-error-while-restoring-database?forum=sqldisasterrecovery IF SOMEONE COULD HELP ME CREATE A NEW DB....THAKS mackie01, Feb 23, 2008 #2 Jack Vamvas Member Does 'D:MUSERVERDBMUONLINE_DATA.MDF' exist? Could you post the script or process - you are using to CREATE DATABASE? Jack Vamvas, Feb 24, 2008 #3 zane New Member Hi There I receive the same error when trying to attached a database. ERROR 5105: DEVICE ACTIVATION ERROR. THE PHYSICAL FILE NAME 'D:xxx xxx http://www.sql-server-performance.com/forum/threads/error-5105-device-activation-error-suspect-database.25624/ xxx.MDF' MIGHT BE INCORRECT... In a previous forum someone mentioned that this might have something to do with the permissions on the d: drive. I am not sure if sql need more permission of the local system account. anyone got an idea as to what i can do. Regards, Zane zane, Sep 30, 2008 #4 ghemant Moderator Hi, See if this applies to your situation http://support.microsoft.com/kb/836873/en-us and http://support.microsoft.com/kb/239759 ghemant, Oct 1, 2008 #5 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? Forgot your password? No, create an account now. Yes, my password is: Stay logged in SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 and 2000 Forum Topics > General DBA Questions > Forums Forums Quick Links Search Forums What's New? Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. Newer Than: Advanced search...
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio http://crm.ittoolbox.com/groups/technical-functional/saleslogix-l/device-activation-error-the-physical-file-name-may-be-incorrect-3804323 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 http://stackoverflow.com/questions/926096/how-to-attach-a-database-without-an-ldf-file MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM PCMag maxwellarnold I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Craig Borysowich Dennis Stevenson Richard mircea_luca Nikki Klein AbhaiTripathi sql server knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Webroot Dell Software Oracle Service Max 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 – General Discussions group. More CRM Groups Your account is ready. You're now being signed in. Solve activate sql server 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. I've moved the database directly into the data folder and attempted to attach with the manual \admin switch. I've tried to attach the same database to a different computer and it worked. The file is
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 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to attach a database without an LDF file? up vote 5 down vote favorite 5 How can I attach a database without an LDF file in SQL Server? sql-server share|improve this question edited May 29 '09 at 13:56 Welbog 41.6k682102 asked May 29 '09 at 13:54 Ricardo 6033823 1 Just have to add that you may get an inconsistent database by doing this. It is much much better to attach it with the original LDF. See blogs.msdn.com/sqlserverstorageengine/archive/2006/06/15/… –Remus Rusanu May 29 '09 at 16:25 add a comment| 8 Answers 8 active oldest votes up vote 8 down vote You can use sp_attach_single_file_db to attach a database which is missing it's log file. share|improve this answer answered May 29 '09 at 13:57 Aaron Alton 13.7k32527 It gives this error: Could not open new database 'SharedCS'. CREATE DATABASE is aborted. Device activation error. The physical file name 'd:\Program Files\Microsoft SQL Server\MSSQL\data\dummy_Log.LDF' may be incorrect. –Ricardo May 29 '09 at 14:11 Don't try to attach a dummy log. Can you post the sp_attach_single_file_db command you're running? –Aaron Alton May 29 '09 at 14:41 1 This only works if the log file can be created anew where the .mdf says it is. –Joshua Dec 15 '11 at 19:37 add a comment| up vote 3 down vote You can try wha