Re: Help with restoring dropped table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 05/22/04 

Date: Sat, 22 May 2004 07:34:21 -0400

If you only have a copy of the data files, you might try to sp_attach_db
using a different name. If the attach works, then you can simple insert
select to get the data moved. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Waldemar" <anonymous@discussions.microsoft.com> wrote in message
news:795D7014-4206-426C-927B-C62E1C1A43F4@microsoft.com...
> What can I do if I do not have a full backup, only a copy of yesterday's
database?

Relevant Pages

  • Re: How to recreate/restore the database from the data and log files
    ... 2)You can use the option 'Attach Database' In Sql EnterPrise manager to ... 3)Open the enterprise manager - Click on your Sql Server group... ... Browse the your Data Files file.... ...
    (microsoft.public.sqlserver.tools)
  • Re: Open mdf in SQL server 2005
    ... You detach the database from SQL Server2K, and copy both data files (*.mdf ... Access2007 to manage SQL Server 2005's server side objects. ... Now I would like to convert open the mdf file in sql server 2005 and I ... I attach but appears an error: Fail to retrive data for this request. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... choice to install sql server binaries of the SQL Server on C drive, ... appears that I am not given the choice to install system databases/log files ... drives must be physically seperated so that you'll gain performance ... We are physically separating log and data files on separate disks. ...
    (microsoft.public.sqlserver.setup)
  • Re: Primary File Group full
    ... SQL Server tries to grow as per the increment specified for the file. ... > the data files. ... Some disks is almost out of disk space but ... >>> in the database that i am creating, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... button in the "Components to Install" window in SQL Server 2005 Setup. ... In 2005 I appear not to be given the choice to install sql server binaries of the SQL Server on C drive, it appears that I am not given the choice to install system databases/log files on a separate drive, as I could in 2000. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
    (microsoft.public.sqlserver.setup)