 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008Attaching MDF and LDF Files Error
i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database on customer site installed on C Partition ....MDF file is 300 MB but LDF file became 12 GB which took all of the C Partition Space.. Our Tech Supp Person have moved these Physical Files From C to D partition and Deleted the files and database from C partition and he created new database and tried to Attach from D partion but that gives an error(Error 9003: The LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is invalid) another problem is that latest backup is not available only old backup available. we restored old backup and tried to attach those files (300 MB and 12 GB) but didnt work.. another error comes that CAN NOT ATTACH FILES FROM DIFFERENT DATABASES. please can any one help in this case ...my email is raza_noor@hotmail.com Hi Was the file detached correctly? Try renaming the log file and using sp_attach_single_file_db to create a new log, and then detaching/move/attaching the log or in SQL 2005 you can use CREATE DATABASE with the ATTACH_REBUILD_LOG option instead of sp_attach_single_file_db. John > i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database > on [quoted text clipped - 16 lines] > > please can any one help in this case ...my email is raza_noor@hotmail.com Hi Does he try top attach with single file option (for more details please see BOL) i.e without specifying .LDF file? Don't you have proper BACKUP? > i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database > on [quoted text clipped - 16 lines] > > please can any one help in this case ...my email is raza_noor@hotmail.com If the Tech Supp Person did no detach database file before move it, he is not qualified to manage a server/computer with production SQL Server. > i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database > on [quoted text clipped - 16 lines] > > please can any one help in this case ...my email is raza_noor@hotmail.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.