Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aliyesami
Starting Member
30 Posts |
 Posted - 2008-08-22 : 18:31:12
|
| I am giving the following restore command to restore the database on drive D but its giving me msg about drive C low on space. funny thing is that the space statistics its showing is of drive D ..RESTORE DATABASE fdt FROM DISK='D:\sql_backups\Data\fdt\fdt_db_200808150200.BAK'WITHMOVE 'fdt_Data' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\data\fdt_data.mdf',MOVE 'fdt_Log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\data\fdt_log.ldf'Server: Msg 3257, Level 16, State 1, Line 1There is insufficient free space on disk volume 'C:\' to create the database. The database requires 94280155136 additional free bytes, while only 68339838976 bytes are available.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
strange restore behavior or is it a bug ?