Restore From Floppy Drive - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore From Floppy Drive

Author

Topic

amitkumarmadhukar
Starting Member

45 Posts

Posted - 2004-08-12 : 08:26:22

Hi Guys,

I am currently using the Restore operation through Command

restore database DBName
From DISk='Filename' with
stats=10,
recovery,
unload,
replace,
restart

this works fine for Restoring operation from Backups On Hard Disks

What Changes i made into it the about Restore command to Restore Database with Backup On either Floppy Drive and CDROM Attached with computer while i don't know the exact drive letter for CDROM attached with computer or don't want to know the drive letter for CDROM attached with PC

Please Can You Help me

and also tell me the Change in backup command if i want take Backups on Floppy Drive, however my cuurent Backup Command is as follows:

Backup Database DatabaseName
To Disk='Filename'

amit kumar madhukar

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-12 : 11:51:39

What Changes i made into it the about Restore command to Restore Database with Backup On either Floppy Drive and CDROM Attached with computer while i don't know the exact drive letter for CDROM attached with computer or don't want to know the drive letter for CDROM attached with PC

You're going to need to know the location. It's the same syntax.

and also tell me the Change in backup command if i want take Backups on Floppy Drive, however my cuurent Backup Command is as follows:

Again, the syntax is the same.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-12 : 11:59:09

Backups on floppy! Why oh why oh why would you want to do this? Backups should always be sent to the local disk first. Then you can copy that file to wherever you want after the backup has completed successfully.

Tara

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-12 : 12:01:29

lol It must be a huge database.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-08-12 : 13:31:26

I about fell outta my chair when I read the subject of this topic.

I kept thinking, yeah let's outsource our database stuff. That's a GREAT idea!

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources