I am trying to back my SQL Server 2000 database (which contains one table) t
o
floppy disk.
I select SQL Server backup option and select destination backup to: A:
When I click OK, I see message that says 'backup in progrress', and then a
message box displays 'The backup operation has been completed successfully'.
At no time did my floppy drive light up and the data did not get backed up
to it.
I don't see where it got backed up to.
Does anyone know why it is not backing up to my floppy drive?
Thanks.Are you performing this operation where the Server installation was made?
SQL Server takes the folders from the machine where its installed and not
that of the client.
thanks and regards
Chandra
"Ron" wrote:
> I am trying to back my SQL Server 2000 database (which contains one table)
to
> floppy disk.
> I select SQL Server backup option and select destination backup to: A:
> When I click OK, I see message that says 'backup in progrress', and then a
> message box displays 'The backup operation has been completed successfully
'.
> At no time did my floppy drive light up and the data did not get backed up
> to it.
> I don't see where it got backed up to.
> Does anyone know why it is not backing up to my floppy drive?
> Thanks.|||Yes I am performing this operation where the Server installation was made.
So how do I backup to floppy?
"Chandra" wrote:
[vbcol=seagreen]
> Are you performing this operation where the Server installation was made?
> SQL Server takes the folders from the machine where its installed and not
> that of the client.
> thanks and regards
> Chandra
>
> "Ron" wrote:
>|||Just see this:
kpt_1m0p.asp" target="_blank">http://msdn.microsoft.com/library/d...>
kpt_1m0p.asp
thanks and regards
Chandra
"Ron" wrote:
[vbcol=seagreen]
> Yes I am performing this operation where the Server installation was made.
> So how do I backup to floppy?
>
> "Chandra" wrote:
>|||Chandra
Those were the exact steps I already took and it didn't back up.
Just to try something different I just tried selecting schedule with todays
date & time and received the message
'SQL Server agent on target (local) is stopped. Make sure it is running
during scheduled execution of this job.'
My target is my floppy drive.
Any ideas whjat is wrong?
"Chandra" wrote:
[vbcol=seagreen]
> Just see this:
> ackpt_1m0p.asp" target="_blank">http://msdn.microsoft.com/library/d...
ackpt_1m0p.asp
> thanks and regards
> Chandra
> "Ron" wrote:
>|||Ron,
Just back it up on a different drive and see whats the size of the backup
file. Is it lee that 1.44 MB
"Ron" wrote:
[vbcol=seagreen]
> Chandra
> Those were the exact steps I already took and it didn't back up.
> Just to try something different I just tried selecting schedule with today
s
> date & time and received the message
> 'SQL Server agent on target (local) is stopped. Make sure it is running
> during scheduled execution of this job.'
> My target is my floppy drive.
> Any ideas whjat is wrong?
> "Chandra" wrote:
>|||Add on to chandra, do the below steps:-
1. Backup the database to hard drive using below command (Execute from Query
Analyzer)
Backup Database <dbname> to disk = 'c:\dbname.bak' with init,stats=10
2. See the size of backup file, if the file size is less than 1.44 MB, copy
the file to floppy. If the file is greater than 1.44 MB then try zipping the
backup file.
If the file come down to < 1.44 MB copy the zip to floppy, else you cant
copy to floppy.
Thanks
Hari
SQL Server MVP
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:C14877A0-1792-4767-A995-AA5D467C734B@.microsoft.com...[vbcol=seagreen]
> Ron,
> Just back it up on a different drive and see whats the size of the backup
> file. Is it lee that 1.44 MB
>
> "Ron" wrote:
>
todays[vbcol=seagreen]
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp[/ur
l][vbcol=seagreen]
made.[vbcol=seagreen]
was made?[vbcol=seagreen]
and not[vbcol=seagreen]
one table) to[vbcol=seagreen]
to: A:[vbcol=seagreen]
and then a[vbcol=seagreen]
successfully'.[vbcol=seagreen]
backed up[vbcol=seagreen]|||I backed up to a folder on my hard drive and it worked fine.
The file size is 915 KB. I then copied it to my floppy drive successfully.
I don't know why I can't backup directly to floppy but at least it works in
2 steps.
Thanks.
"Chandra" wrote:
[vbcol=seagreen]
> Ron,
> Just back it up on a different drive and see whats the size of the backup
> file. Is it lee that 1.44 MB
>
> "Ron" wrote:
>
No comments:
Post a Comment