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

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

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

1> BACKUP DATABASE DIGITAL_01 TO DISK = 'C:\DIGITAL_01.BAK'
2>

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.

Thanks,

nriacone
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

tkizer
Almighty SQL Goddess

USA
35954 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
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   Topic Next Topic  
 New 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