🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: dk.edb.database
Article #15290

Re: Flytning af SQL Server 7 db fra en server til en anden

#15290
From: Stig Johansen
Date: Fri, 08 Jun 2001 04:18
18 lines
1475 bytes
MacMan wrote:

> Hej,
> 
> Er der nogen der ved hvordan man smartest flytter en SQL Server database
> fra en server til en anden?
> Jeg har pr�vet at lave en eksport fra den ene server til den anden, men s�
> glemmer den IDENTITY'er og default v�rdier :-/
> 

Brug detach -> kopier filer -> attach

Se Q224071 for ydeligere info.

-- 
Med venlig hilsen / Best regards
Stig Johansen
linux@w3data.dk
Technical Details
Message-ID: <9fpjlu$jet$1@sunsite.dk>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newscore.gigabell.net!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!130.225.51.30!sunsite.dk!not-for-mail
References: <HJUT6.10206$R84.1270416@news010.worldonline.dk>

Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,b4310447ada52368
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-07 21:18:22 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newscore.gigabell.net!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!130.225.51.30!sunsite.dk!not-for-mail
From: Stig Johansen <linux@w3data.dk>
Newsgroups: dk.edb.database
Subject: Re: Flytning af SQL Server 7 db fra en server til en anden
Date: Fri, 8 Jun 2001 06:18:20 +0200
Organization: W3 Data ApS
Lines: 18
Sender: stig@62.242.196.205
Message-ID: <9fpjlu$jet$1@sunsite.dk>
References: <HJUT6.10206$R84.1270416@news010.worldonline.dk>
NNTP-Posting-Host: 62.242.196.205
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8Bit
X-Trace: sunsite.dk 991973886 19933 62.242.196.205 (8 Jun 2001 04:18:06 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Fri, 8 Jun 2001 04:18:06 +0000 (UTC)
X-Authenticated: stig@w3data.dk
User-Agent: KNode/0.4