Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Backup 8.00.761 with OSQL
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

6 Posts

Posted - 12/29/2013 :  20:02:22  Show Profile  Reply with Quote
I have an application that is required to run in a Windows XP Professional environment using SQL Server Desktop Engine 8.00.761. I have tried using OSQL. The syntax I have tried from a command prompt is:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -E

At the prompt I enter the following:


I receive no response from the command and no file is generated in the C:\ directory. This appears to be a simple operation, but I cannot get the command to generate a backup. If there is a better method to back up the file I would be open to suggestions.


Starting Member

6 Posts

Posted - 12/29/2013 :  20:24:35  Show Profile  Reply with Quote
Hello All,

Rookie mistake, I was not aware that the command is cached and that you have to type go at the "2>" prompt. That being said, the original MDF file is 2,097,152 KB and the backup file is 109,585 KB. Does the backup operation compress/optimize the file?

Thanks again,
Go to Top of Page

Almighty SQL Goddess

38200 Posts

Posted - 12/30/2013 :  13:24:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
SQL 2000 did not have the compression option. It was added in 2008. Your backup file size is smaller than the MDF file because the backup file size reflects the size that is in use inside the MDF. So even though your MDF is using 2097152kb on disk, the actual size in use INSIDE the file is closer to the size of the backup file.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000