Forum

SQL Server 2005 Att...
 
Bildirimler
Hepsini Temizle

SQL Server 2005 Attach Database

10 Yazılar
5 Üyeler
0 Reactions
2,602 Görüntüleme
(@MustafaDemirhan)
Gönderiler: 23
Eminent Member
Konu başlatıcı
 

Merhabalar;

Sql server 2005 içine database attach yaparken şu hata ile karşılaşıyorum ne yapmam gerekir? bilen yardımcı olursa minnettar kalırım şimdiden teşekkürler.

Karşılaştığım hata :

 TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'OKYANUS03\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The log scan number (333:2653:1) passed to log scan in database 'analist' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Could not open new database 'analist'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 9003)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=9003&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 
Gönderildi : 31/08/2010 17:24

(@turgaysahtiyan)
Gönderiler: 344
Reputable Member
 

DB yi log dosyasız attach etmeyi dener misin? aşağıdaki makalede nasıl yapıldığını inceleyebilirsin.

http://turgaysahtiyan.com/post/SQL-Server-Log-Dosyasc4b1-Olmadan-Database-i-Attach-Yapmak-(Attach-e28093-Detach).aspx  

 
Gönderildi : 31/08/2010 17:59

(@MustafaDemirhan)
Gönderiler: 23
Eminent Member
Konu başlatıcı
 

Hemen bakıyorum ilgine teşekkürler..[:)]

 
Gönderildi : 31/08/2010 18:48

(@MustafaDemirhan)
Gönderiler: 23
Eminent Member
Konu başlatıcı
 

Hemen bakıyorum ilgine teşekkürler [:)]

 
Gönderildi : 31/08/2010 18:49

(@MustafaDemirhan)
Gönderiler: 23
Eminent Member
Konu başlatıcı
 

Teşekkürler tuygay be sorunum çözüldü...

 
Gönderildi : 31/08/2010 19:13

(@turgaysahtiyan)
Gönderiler: 344
Reputable Member
 

Rica ederim geçmiş olsun 🙂

 
Gönderildi : 31/08/2010 19:15

(@ercumentumruk)
Gönderiler: 1
New Member
 

merhaba bende benzer bir durumla karşılaştım yani hata aldım,ama ben northwind db i eklemek istedim

aşağıda errorr logu yazıyorum yarım rica ederim

teşekkürler

===================================

Attach database failed for Server 'EMRE-PC'.  (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)

===================================

Unable to open the physical file "C:\SQL2000.Sample.Databases.(Northwind,pubs)\northwnd.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

------------------------------
Server Name: EMRE-PC
Error Number: 5120
Severity: 16
State: 101
Line Number: 1


------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

 
Gönderildi : 17/10/2010 23:02

(@turgaysahtiyan)
Gönderiler: 344
Reputable Member
 

C:\SQL2000.Sample.Databases.(Northwind,pubs)\northwnd.mdf dosyası üzerindeki yetkileri kontrol eder misiniz? Attach i yapmaya çalıştığınız win acc nin bu dosyada yetkisi yokmuş gibi gözüküyor.

 
Gönderildi : 18/10/2010 13:15

(@Sevketicli)
Gönderiler: 3
New Member
 

tesekkurler 🙂

 
Gönderildi : 23/01/2011 02:00

(@FatmaSERDAROGLU)
Gönderiler: 1
New Member
 

DB yi log dosyasız attach etmeyi dener misin? aşağıdaki makalede nasıl yapıldığını inceleyebilirsin.

http://turgaysahtiyan.com/post/SQL-Server-Log-Dosyasc4b1-Olmadan-Database-i-Attach-Yapmak-(Attach-e28093-Detach).aspx  

 

 

TITLE: Microsoft SQL Server Management Studio

------------------------------

Attach database failed for Server 'FATMASERDAROĞLU\DATABASEM'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1846+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The file "D:\AcikAkademi\AdventureWorksLT2012_Database\AdventureWorksLT2012_Data.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

Could not open File Control Block (FCB) for invalid file ID 2 in database 'AdventureWorksLT2012'. Verify the file location. Execute DBCC CHECKDB.

Could not open new database 'AdventureWorksLT2012'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 5118)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=5118&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------

Hocam benim hatamda bu ancak bir türlü cevap bulamadım. Yardımcı olursanız çok sevinirim. 

 
Gönderildi : 11/01/2015 18:54

Paylaş: