| Author |
Topic |
|
mohit_sharan
Starting Member
22 Posts |
 Posted - 2005-08-03 : 10:55:51
|
| Hi All,I have a 90 GB backup file. I don't have enough space in my test database SQL Server 2000 to restore it. I had maped it to my test server. But SQL Server 2000 is not able to recognise the map drive. Can any one plz tell me how to restore the database from Map drive. My OS is windows 2000 server and database is SQL Server 2000 Enterprise Edition.Thanks in Advance.-Mohit. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-03 : 15:14:41
|
| RESTORE DATABASE DBNameFROM DISK = '\\SomeOtherServer\SomeShare\SomeBackupFile.BAK'WITH REPLACE, ...Tara |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-03 : 16:32:48
|
| He does'nt like that answer. i gave it to him some place else earlier today. gave him another. never heard back.====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-03 : 16:35:39
|
| He probably wants the Enterprise Manager answer. Why are people so afraid of Query Analyzer?Tara |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-03 : 16:52:36
|
I'm afraid of using Enterprise Manager for restores; I never seem to get it right.quote:
Originally posted by tduggan
He probably wants the Enterprise Manager answer. Why are people so afraid of Query Analyzer?Tara
CODO ERGO SUM |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2005-08-04 : 13:20:08
|
| UNC path for DB restor works in EM:In EM:Right click and choose "All Tasks" choose "Restore Database" choose "From Device" choose "Select Device" click "Add" click "Filename" Enter the UNC path to the DB Backup File. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-04 : 14:35:36
|
"Why are people so afraid of Query Analyzer"Because they know they lack the day-to-day knowledge of what can do wrong, and thus will not spot it for what it is.Mind you, EM is very "out of sight out of mind"!So, do a restore of a DB into a new database using EM. What are the logical names of the disk bits & pieces - same as the original DB or nicely changed to represent the new DB?Restore an existing database, from its own backups (made with 10 minute interval logs until 15 minutes before the crash, last full backup was 22 hours ago). Use EM? Piece of cake and a couple of mouse clicks ... Script it? "When do you need it by restored by?"  Kristen |
|
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-08-04 : 22:48:37
|
| Always Query Analyzer. Never trust EM for backup/restore operations.--sri |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2005-08-05 : 10:14:33
|
| Never trust EM for Restores?I use it all the time and it WORKS. One still needs to double check all the fields to make sure that the GUI is going to do what you want...force restore, change the .mdf .ldf names etc...DeWayne |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-05 : 10:16:22
|
| "One still needs to double check all the fields to make sure that the GUI is going to do what you want...force restore, change the .mdf .ldf names etc..."That's a pain 'coz one day someone forgets one. And you can't configure EM to force you to "Do it your way" :-( I've got an SProc that does it My Way!Kristen |
|
|
|
lucykou
Starting Member
6 Posts |
Posted - 2005-08-08 : 09:49:30
|
Kristen,I noticed you replied on a DB backup topic by asking if that backed up to a remote filesystem. I got the error message: "[SQLSTATE 01000] (Message 4035) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed." when I tried to back up the complete database to a remote drive. But the transaction back up to the same drive works just fine. Any idea why and how to avoid the error?Thank you very much!Lucyquote:
Originally posted by Kristen
"One still needs to double check all the fields to make sure that the GUI is going to do what you want...force restore, change the .mdf .ldf names etc..."That's a pain 'coz one day someone forgets one. And you can't configure EM to force you to "Do it your way" :-( I've got an SProc that does it My Way!Kristen
|
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-08 : 14:29:44
|
| He lucykou, Welcome to SQL Team!I don't think I'll be much help. I've never backed up to a remote filesystem, but I agree with you that if a transaction backup works then a full backup should.Dumb question: Is there enough disk space on the remote system for the full backup?Kristen |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-08 : 14:36:44
|
| didn't read the entire thread (lazy), but you should be using the UNC path of the destination, not a drive letter.-ec |
|
|
|
lucykou
Starting Member
6 Posts |
Posted - 2005-08-08 : 14:42:47
|
Thanks, Kristen.Yes, there is enough space in the remote system. The complete backup file is about 7G bytes. Probably it's too big to be backed up to remote system.Lucyquote:
Originally posted by Kristen
He lucykou, Welcome to SQL Team!I don't think I'll be much help. I've never backed up to a remote filesystem, but I agree with you that if a transaction backup works then a full backup should.Dumb question: Is there enough disk space on the remote system for the full backup?Kristen
|
|
|
|
lucykou
Starting Member
6 Posts |
Posted - 2005-08-08 : 14:45:13
|
thanks, ec. I was using UNC path. The transaction and differential backup worked fine. Only the complete backup failed.Lucyquote:
Originally posted by eyechart
didn't read the entire thread (lazy), but you should be using the UNC path of the destination, not a drive letter.-ec
|
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-08 : 15:17:24
|
| Some sort of timeout error possibly? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-08 : 15:56:24
|
| Lucy,are you backing up to an NTFS file system?Try a full backup of a smaller database and see if it works. Something just under 2GB would be a good test.Also, you might want to start a new thread on this subject. There might be some people who figure this question is already answered and don't read the thread (or are lazy like me :) and don't read it all the way through)-ec |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-08 : 16:07:13
|
quote:
Originally posted by X002548
Anyone want to mention here that doing a restore across a network is not a good idea?Anyone?OK, I will.It is not a good idea.Brett
How is that different than pulling a backup from tape from across your network?-ec |
|
|
|
lucykou
Starting Member
6 Posts |
Posted - 2005-08-08 : 16:27:42
|
ec,Yes, it's NTFS file system. The full backup of a smaller database works great. So the problem must be the file size.thanks again for the suggestions. I'll need to figure out how to work around it.Lucyquote:
Originally posted by eyechart
Lucy,are you backing up to an NTFS file system?Try a full backup of a smaller database and see if it works. Something just under 2GB would be a good test.Also, you might want to start a new thread on this subject. There might be some people who figure this question is already answered and don't read the thread (or are lazy like me :) and don't read it all the way through)-ec
|
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-08 : 16:45:00
|
quote:
Originally posted by lucykou
ec,Yes, it's NTFS file system. The full backup of a smaller database works great. So the problem must be the file size.thanks again for the suggestions. I'll need to figure out how to work around it.Lucy
Lucy, we backup to remote filesystems all the time and do not have any problem with database size or filesize limitations. Do you have a quota in place on the NTFS partition?Can you manually copy a large file to that same location?-ec |
|
|
|
Next Page
|
How to Restore Database from Map netwrok Drive.