Re: Loading db from copied files
From: Jim McDonald (jim_at_missile.demon.co.uk)
Date: 02/04/05
- Next message: Gansmeier: "Re: SQL Server statistics Counter"
- Previous message: Mike Epprecht (SQL MVP): "RE: Is this even possible?"
- In reply to: Dejan Sarka: "Re: Loading db from copied files"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Feb 2005 12:57:21 -0000
Dejan
Thanks 10^6. Worked a treat.
Jim Mc
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:uIgtSwhCFHA.3504@TK2MSFTNGP12.phx.gbl...
> Check the sp_attach_db system sp in Books OnLine.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
> "Jim McDonald" <jim@missile.demon.co.uk> wrote in message
> news:cttp54$4rf$1$830fa17d@news.demon.co.uk...
>> Hi
>> I have copied the db and log files from a backup disk to \program
>> files\...MSSQL\....Data\ which is where all the other dbs are (eg
> Northwind)
>> but I cant get the console to recognise the new copied-in db.
>> For various reasons the normal DTS approach wont work... has any kind
> person
>> got any advice / answer on this??
>> Thanks
>> Jim McDonald
>>
>>
>
>
- Next message: Gansmeier: "Re: SQL Server statistics Counter"
- Previous message: Mike Epprecht (SQL MVP): "RE: Is this even possible?"
- In reply to: Dejan Sarka: "Re: Loading db from copied files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
