John W. Colby
jcolby at colbyconsulting.com
Thu Nov 13 09:59:14 CST 2003
Karen, I don't think so. What I mean is that I have a pair of files called C2DbBilling.mdf and C2DbBilling_log.ldf. It appears that these are the database files for my billing, though I am not certain. I need to tell SQL Server to open these objects and display the data inside them. John W. Colby www.colbyconsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Nicholson, Karen Sent: Thursday, November 13, 2003 10:35 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Help - get db back To connect to a new server, I go to Start, Control Panel, data sources and then add the server I want to be able to access. Does that work? -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, November 13, 2003 10:28 AM To: SQLServer Subject: [dba-SQLServer]Help - get db back Folks, I had a hard disk decide to disappear occasionally. Yep, a soft reboot would show it completely missing, only a hard boot (power off/on) would display it again. Of course it was my system disk. In the two days of screwing around finding and fixing it, I forgot to back up my SQL Server database. It appears that I was connected to a database out on my data disk, and I didn't lose it, but the question is, how do I "attach to" that SQL Server database? It's my billing database and rather critical. Again, I have the database itself, but it is out in my data directory and I need to get SQL Server to open it and let me use it. Possible? John W. Colby www.colbyconsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com