Backup database to floppy

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.
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:
http://msdn.microsoft.com/library/de...ackpt_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:
> http://msdn.microsoft.com/library/de...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 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:
|||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]
http://msdn.microsoft.com/library/de...ackpt_1m0p.asp[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:

Backup database to floppy

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:
>

Backup database to floppy

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.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:
> 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.|||Just see this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp
thanks and regards
Chandra
"Ron" wrote:
> Yes I am performing this operation where the Server installation was made.
> So how do I backup to floppy?
>
> "Chandra" wrote:
> >
> > 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.|||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:
> Just see this:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp
> thanks and regards
> Chandra
> "Ron" wrote:
> > Yes I am performing this operation where the Server installation was made.
> > So how do I backup to floppy?
> >
> >
> > "Chandra" wrote:
> >
> > >
> > > 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.|||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:
> 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:
> >
> > Just see this:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp
> >
> > thanks and regards
> > Chandra
> >
> > "Ron" wrote:
> >
> > > Yes I am performing this operation where the Server installation was made.
> > > So how do I backup to floppy?
> > >
> > >
> > > "Chandra" wrote:
> > >
> > > >
> > > > 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.|||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...
> 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:
> > 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:
> >
> > >
> > > Just see this:
> > >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp
> > >
> > > thanks and regards
> > > Chandra
> > >
> > > "Ron" wrote:
> > >
> > > > Yes I am performing this operation where the Server installation was
made.
> > > > So how do I backup to floppy?
> > > >
> > > >
> > > > "Chandra" wrote:
> > > >
> > > > >
> > > > > 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.|||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:
> 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:
> > 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:
> >
> > >
> > > Just see this:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp
> > >
> > > thanks and regards
> > > Chandra
> > >
> > > "Ron" wrote:
> > >
> > > > Yes I am performing this operation where the Server installation was made.
> > > > So how do I backup to floppy?
> > > >
> > > >
> > > > "Chandra" wrote:
> > > >
> > > > >
> > > > > 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.

Backup Contains .mdf .ldf and .ndf dont want .ndf

Hello,
I have a database(.mdf and .ldf) with a large table that is attached to
its own filegroup(.ndf). I have created a full database backup and used
Restore FilelistOnly From Disk = 'C:\MSSQL\Data\Backup\Contact.bak'
I see 3 files
contact.mdf
contact.ldf
cont.ndf
I restored just the .mdf and .ldf to another database and when I look at
the properties and goto file groups it shows that the filegroup is still
there too. How is the ndf a part of this database when I never restored
the .ndf
I wan to restore only .mdf and .ldf and leave the .ndf behind is this
possible and how. Thanks for all HELP!
*** Sent via Developersdex http://www.examnotes.net ***First, if you don't supply a "WITH MOVE" clause for the .ndf file, it will
use the original file path from where the backup was created. Second, if
you do a full database restore, you must restore all the files. You cannot
omit any files. You can delete the file/filegroup after the restore is
completed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sean John" <sj@.aol.com> wrote in message
news:eoNsFaTHGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have a database(.mdf and .ldf) with a large table that is attached to
> its own filegroup(.ndf). I have created a full database backup and used
> Restore FilelistOnly From Disk = 'C:\MSSQL\Data\Backup\Contact.bak'
> I see 3 files
> contact.mdf
> contact.ldf
> cont.ndf
> I restored just the .mdf and .ldf to another database and when I look at
> the properties and goto file groups it shows that the filegroup is still
> there too. How is the ndf a part of this database when I never restored
> the .ndf
> I wan to restore only .mdf and .ldf and leave the .ndf behind is this
> possible and how. Thanks for all HELP!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||When trying to delete file it says that
The file 'Contact'cannot be removed because it is not empty.
Is there a way to backup only .mdf or .ldf or restore just .mdf or .ldf
and no .ndf?
*** Sent via Developersdex http://www.examnotes.net ***|||Have a look in BOL under DBCC SHRINKFILE specifically the EMPTYFILE option
and then ALTER DATABASE specifically the REMOVE FILE option.
Andrew J. Kelly SQL MVP
"Sean John" <sj@.aol.com> wrote in message
news:O3$1kXUHGHA.1424@.TK2MSFTNGP12.phx.gbl...
> When trying to delete file it says that
> The file 'Contact'cannot be removed because it is not empty.
> Is there a way to backup only .mdf or .ldf or restore just .mdf or .ldf
> and no .ndf?
>
> *** Sent via Developersdex http://www.examnotes.net ***|||You have to delete all user objects from the file.filegroup. Then folow
Andrew's instructions.
Backups and restores always require a full database to work with. You can
do a filegroup backup, but it must be restored to a full database. The
short answer is no, you cannot transfer part of a database using backup and
restore. The tools simply do not work that way.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sean John" <sj@.aol.com> wrote in message
news:O3$1kXUHGHA.1424@.TK2MSFTNGP12.phx.gbl...
> When trying to delete file it says that
> The file 'Contact'cannot be removed because it is not empty.
> Is there a way to backup only .mdf or .ldf or restore just .mdf or .ldf
> and no .ndf?
>
> *** Sent via Developersdex http://www.examnotes.net ***

Backup

If a 250 MB database contains only 30 MB of data, how much of the database is written when the database is backed up? Why?
a. 30 MB
b. 250 MB
c. 220 MB
d. 60 MBIf you have a 250Mb Db which only contains 30Mb of data. Then the backup should be around the 30Mb mark give or take.

A database being 250Mb in size, most likely would include data, transaction log and unused space. Your transaction log is not included in a full database dump. And the space allocated to your db which is not currently filled with data is also not backed up.

I'm sure the answer also depends on your version of SQL Server as well. Does this answer your question?

Originally posted by ssivaprasad
If a 250 MB database contains only 30 MB of data, how much of the database is written when the database is backed up? Why?
a. 30 MB
b. 250 MB
c. 220 MB
d. 60 MB|||Valid explanation by Bmalar, looks like you(siva) struck with one of questions from certifications.