Create Log file and attach Data file in SQL Server

You can attach a SQL Server data file(.mdf) which has no log file(.ldf) associate with the data file.

Use the following SQL Query with the correct path of the data file. 

CREATE DATABASE MyDB
ON (FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MyDB_Data.mdf’)  — change the drive and file path
FOR ATTACH_REBUILD_LOG ;





Advertisement



	

			


	

		
Author: Indika Abayarathne


		

			MSc in IT [University of Colombo] 
Solutions Architect | Consultant

Technologies:
Power Platform | Dynamics CE | Azure			
		

	



	


	






	
	
		

		
Leave a Reply 





	
	






	

		
Fill in your details below or click an icon to log in:

		
	


	

		

			

				Gravatar
			


				

				
				

					
					

				

				

					
					

				

			

			
		

	


	

		

			

				WordPress.com Logo
			


				

				
				
				
						

			
			You are commenting using your WordPress.com account.			
				( Log Out / 
				Change )
			
			
		

					

	
		

	


	

		

			

				Facebook photo
			


				

				
				
				
						

			
			You are commenting using your Facebook account.			
				( Log Out / 
				Change )
			
			
		

					

	
		

	



	

		
Cancel

		
Connecting to %s

	









	
 
 






 





	

	




	
	


	




	

		


		
	









	

		

	

	

	



				
		

		
		



	
	


	
	
				






	
	

		

			%d bloggers like this: