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
 MSDE (2000)
 Backup 8.00.761 with OSQL

Author  Topic 

nriacone
Starting Member

6 Posts

Posted - 2013-12-29 : 20:02:22
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 - 2013-12-29 : 20:24:35
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

38200 Posts

Posted - 2013-12-30 : 13:24:28
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
   

- Advertisement -