Error in moving database to another server

[Sujit]

Hi

I have to copy (move) a database from one server to another .
One of the way of doing it is to take backup at source server and restore it at destination server .

I am doing it with the following series of statements .

================
At Source Server
================

USE master

EXEC sp_addumpdevice 'disk', 'DBName_Device',
'\Irhahadb01F$mssqlackupDBName_Device.dat&#39 ;

BACKUP DATABASE DBName TO DBName_device


=====================
At Destination Server
=====================

--Copy file (DBName_Device.Dat) from Source backup folder to Destination Backup folder

USE master
EXEC sp_addumpdevice 'disk', 'DBName_Device',
'\Irhadvdb02D$mssql7ackupDBName3_Device.dat&# 39;

RESTORE DATABASE DBName
FROM DBName_Device
WITH RECOVERY,
MOVE &#39;<Data File Name without .mdf>&#39; TO
&#39;\irhadvdb02D$mssql7data<New Data File Name>.mdf&#39; ,
MOVE &#39;<Log File name without .ldf>&#39; TO
&#39;\irhadvdb02D$mssql7data<New Log File Name>.ldf&#39;


Above step works fine for one of the test database which small in size.

But it fails for the large database having Data file (.mdf) as 2.5GB and log file as 1.5GB .It says &#34; not enough space on network drive to restore database&#34; . But fact is that I have 200 GB free space on the server .

Please advice .

Sujit
860 520 7454

[Anu]

To Make simple,

Source server:

backup database db1 to disk=&#34;\driveackup directoryfilename.bak&#34;

Destination server:

create database db1 in the physical loacation (data and log

restore db1 from disk=&#34;\driveackup directoryfilename.bak&#34;
with replace,move &#34;logical_name for data&#34; to &#34;physical location of data&#34;
move &#34;logical_name for log&#34; to &#34;physical location of log&#34;


- Anu





------------
Sujit at 6/20/01 5:00:56 PM

Hi

I have to copy (move) a database from one server to another .
One of the way of doing it is to take backup at source server and restore it at destination server .

I am doing it with the following series of statements .

================
At Source Server
================

USE master

EXEC sp_addumpdevice &#39;disk&#39;, &#39;DBName_Device&#39;,
&#39;\Irhahadb01F$mssqlackupDBName_Device.dat&#39 ;

BACKUP DATABASE DBName TO DBName_device


=====================
At Destination Server
=====================

--Copy file (DBName_Device.Dat) from Source backup folder to Destination Backup folder

USE master
EXEC sp_addumpdevice &#39;disk&#39;, &#39;DBName_Device&#39;,
&#39;\Irhadvdb02D$mssql7ackupDBName3_Device.dat&# 39;

RESTORE DATABASE DBName
FROM DBName_Device
WITH RECOVERY,
MOVE &#39;<Data File Name without .mdf>&#39; TO
&#39;\irhadvdb02D$mssql7data<New Data File Name>.mdf&#39; ,
MOVE &#39;<Log File name without .ldf>&#39; TO
&#39;\irhadvdb02D$mssql7data<New Log File Name>.ldf&#39;


Above step works fine for one of the test database which small in size.

But it fails for the large database having Data file (.mdf) as 2.5GB and log file as 1.5GB .It says &#34; not enough space on network drive to restore database&#34; . But fact is that I have 200 GB free space on the server .

Please advice .

Sujit
860 520 7454

[babu]

it might be the drive where you are placing the file is running out of space and there might be some temp objects eating the space.

------------
Sujit at 6/20/01 5:00:56 PM

Hi

I have to copy (move) a database from one server to another .
One of the way of doing it is to take backup at source server and restore it at destination server .

I am doing it with the following series of statements .

================
At Source Server
================

USE master

EXEC sp_addumpdevice &#39;disk&#39;, &#39;DBName_Device&#39;,
&#39;\Irhahadb01F$mssqlackupDBName_Device.dat&#39 ;

BACKUP DATABASE DBName TO DBName_device


=====================
At Destination Server
=====================

--Copy file (DBName_Device.Dat) from Source backup folder to Destination Backup folder

USE master
EXEC sp_addumpdevice &#39;disk&#39;, &#39;DBName_Device&#39;,
&#39;\Irhadvdb02D$mssql7ackupDBName3_Device.dat&# 39;

RESTORE DATABASE DBName
FROM DBName_Device
WITH RECOVERY,
MOVE &#39;<Data File Name without .mdf>&#39; TO
&#39;\irhadvdb02D$mssql7data<New Data File Name>.mdf&#39; ,
MOVE &#39;<Log File name without .ldf>&#39; TO
&#39;\irhadvdb02D$mssql7data<New Log File Name>.ldf&#39;


Above step works fine for one of the test database which small in size.

But it fails for the large database having Data file (.mdf) as 2.5GB and log file as 1.5GB .It says &#34; not enough space on network drive to restore database&#34; . But fact is that I have 200 GB free space on the server .

Please advice .

Sujit
860 520 7454