Tuesday, January 06, 2009 Register   Login   
   You Are Here: Discussions      
 SQL Community Portal
  
 Recently Submitted Articles
  
 Recent SQL Clinic Articles
  
 SQL Server Discussion Forums
 
  SQL Server Forums  Discussions  SQL Server Trou...  Attaching DB with only mdf file and few ndf files. no ldf available.
Previous Previous
 
Next Next
New Post 8/18/2008 7:32 PM
User is offline Venkat Katabathuni
1 posts
No Ranking


Attaching DB with only mdf file and few ndf files. no ldf available. 
Hi Friends,
I detached my DB and copied the mdf,ndf,ldf fiels to another location. But some how i lost some of the ndf files as well as ldf file. Out of 15 ndf files i have only 5 ndf files. the ndf files i lost belongs to several file groups. Some of the tables have table partitions also. Now i would like to make the DB up. I dont bother about the data in the DB also. Could anyone please help me to make it up. By the way, i am using SQL Server 2005.
Thanks & Regards,
Venkat
 
 Page 1 of 1
Previous Previous
 
Next Next
  SQL Server Forums  Discussions  SQL Server Trou...  Attaching DB with only mdf file and few ndf files. no ldf available.
  
   Minimize

  
SQL Server 2000 Downloads
 
SQL Server 2000 Reporting Services Downloads
 
SQL Server 2000 Notification Services SP Downloads
 
SQL Server CE Downloads
 
SQLXML 3.0 Service Pack Downloads
 
SQL Server 2000 JDBC Driver
 
MDAC 2.6 Download
 
SQL Server 2000 Tools Downloads
SQL Server 2005 & SQL Server 2000 Best Practices
·    DMV Stats
 
·    Buffer Cache
·    Input/Output
·    Performance
·    Tempdb
·    Wait Statistics
                    
SQL Server 2000 Best Practices




Cancel   Send

 Community Sharing Central