Re: SQL Desktop Edition

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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 11:23:05 +0100

Copying the files is not enough. You need to make the database files available in SLQ server. Check
out the sp_attach_db stored procedure. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"StevieD" <StevieD@discussions.microsoft.com> wrote in message
news:A410E47D-D36A-472E-A4B4-4830F8C12B3D@microsoft.com...
> Hi,
>
> I've got a slight issue using the free Microsoft SQL Desktop engine, release
> A.
>
> Basically I've installed a new server for our Internet usage reporting, and
> I'm looking to move the database over.
>
> I've copied the .mdf & .ldf files onto the new server into the Microsoft SQL
> Server>MSSQL>Data folder.
>
> When I'm creating a new data source via ODBC admin through administrative
> tools, under "Change the default" database I do not have the database name of
> the database I've copied over from my old server.
>
> I've tried restarting the SQL services on the server but with success.
>
> I'm a rookie with SQL, so can you tell me if this is possible ?  If so, how
> do I achieve this ?
>
> Many thanks,
> Steve

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)