Re: ldf file missing...
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/16/05
- Next message: Tibor Karaszi: "Re: Backup"
- Previous message: Tom Moreau: "Re: How to split large mdf file to smaller files"
- In reply to: Umut Nazlica: "RE: ldf file missing..."
- Next in thread: Andrea Perrotta: "Re: ldf file missing..."
- Reply: Andrea Perrotta: "Re: ldf file missing..."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Feb 2005 13:19:10 +0100
> new log file will be created and you can see the db in EM.
A new log file can only be created under certain circumstances:
1. Database was cleanly detached.
2. Database has only two files: one database mdf file and one log file.
If above two are not true, we are left to pure luck if sp_attach_single_file db work or fail. This
is clearly documented in Books Online. Andrea didn't mention whether both above conditions are
satisfied, so attaching cannot be expected to work.
For Andrea, best now it to restore from most recent backup. If that is undesirable, contact
Microsoft Support.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Umut Nazlica" <UmutNazlica@discussions.microsoft.com> wrote in message news:DB0428CC-62F0-4E35-9C00-D9D385C9DCBF@microsoft.com... > Are you sure that db is not attached? > > Did you refresh EM and see db is there. > > Create a db name TEST, and dettach the db, delete the log file. > > Try this: (You need the change the location regarding to your configuration) > > exec sp_attach_single_file_db > @dbname = 'TEST', > @physname = 'd:\Program Files\Microsoft SQL Server\MSSQL\Data\TEST_Data.MDF' > > You'll get: > > Device activation error. The physical file name 'D:\Program Files\Microsoft > SQL Server\MSSQL\data\TEST_Log.LDF' may be incorrect. > New log file 'd:\Program Files\Microsoft SQL Server\MSSQL\Data\TEST_log.LDF' > was created. > > new log file will be created and you can see the db in EM. > > "Andrea Perrotta" wrote: > >> Hi all, >> the transaction log file db_log.ldf (16 GB) is broken and now is missing. >> on onther server i tried: >> exec sp_attach_single_file_db >> @dbname = 'db_name', >> @physname = 'db_name_data.MDF' >> ....and this is the error: >> ------------------------------------------ >> Server: Msg 1813, Level 16, State 2, Line 1 >> Could not open new database 'GLHP-IS'. CREATE DATABASE is aborted. >> Device activation error. The physical file name 'x:db_log.LDF' may be >> incorrect. >> -------------------------------------------- >> I tried also to create a new DB with same name on same path for the devices >> and >> after detach this db and re-execute sp_attach_single_file_db with the old >> "db_name_data.MDF" >> and the new "db_name_log.LDF" and this is the new error: >> --------------------------------------------------- >> Server: Msg 5173, Level 16, State 1, Line 1 >> Cannot associate files with different databases. >> Server: Msg 1813, Level 16, State 1, Line 1 >> Could not open new database 'GLHP-IS'. CREATE DATABASE is aborted. >> Log file 'x:db_log.LDF' does not match the primary file. It may be from a >> different database or the log may have been rebuilt previously. >> ---------------------------------------------------------- >> I need HELP! >> Andrea Perrotta >> >> >>
- Next message: Tibor Karaszi: "Re: Backup"
- Previous message: Tom Moreau: "Re: How to split large mdf file to smaller files"
- In reply to: Umut Nazlica: "RE: ldf file missing..."
- Next in thread: Andrea Perrotta: "Re: ldf file missing..."
- Reply: Andrea Perrotta: "Re: ldf file missing..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
