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 |
|
mzainaldeen
Starting Member
1 Post |
 Posted - 2008-10-06 : 04:10:42
|
| I am trying to restore using one of my .bak file and the restore failed.Sql server report this:System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 10462641600 additional free bytes, while only 5003348143 bytes are available. (Microsoft.SqlServer.Smo)than i restore the database to a system with more disk space the problem still.Any help will be much appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 04:25:00
|
| http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3230376&SiteID=17http://seer.support.veritas.com/docs/262416.htm |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-06 : 10:00:40
|
| you need to change your location of MDf and LDf file while restoring. |
|
|
|
james_wells
Yak Posting Veteran
55 Posts |
Posted - 2008-10-06 : 16:35:34
|
| example on how to restore to a different location use master;restore filelistonlyfrom disk = 'backup_drive:backup_path\backup_name'displays the logical name and path\name of the database files when they were backed upuse master;restore database DATABASE_NAMEfrom disk = 'backup_drive:backup_path\backup_name'withmove 'DATA_FILE_NAME' TO 'new_drive:new_path\data_file_name' ,move 'LOG_FILE_NAME' TO 'new_drive:new_path\log_file_name' |
|
|
|
|
|
|
restore faild