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.
| 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 -EAt 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, |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Backup 8.00.761 with OSQL