Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fullbackup succeeded but no files in disk Expand / Collapse
Author
Message
Posted Monday, February 11, 2013 8:53 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
Hi ,


we are taking full backups every date with script .backup job status is successfull but only one or two databses full backup files exist in the disk. We have enough disk space on the server.

Thanks,
lavanya
Post #1418729
Posted Tuesday, February 12, 2013 2:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 4:10 AM
Points: 102, Visits: 406
Pls provide the script
Post #1418813
Posted Tuesday, February 12, 2013 5:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:39 AM
Points: 12,744, Visits: 31,085
could the script be overwriting the same backup file with differnet databases?
ie the db "Dictionary" gets backed up to C:\Data\Backup.bak, and then the database "SandBox" overwrites teh exact same file C:\Data\Backup.bak with it's backup, instead of being named to match the db?

without the script we can only make guesses, but it's most likely a problem int he script...bad path, overwriting the smae file, appending too the same file, or something.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1418902
Posted Tuesday, February 12, 2013 6:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 3,734, Visits: 7,077
Are you using a custom script or are you using a Maintenance Plan? Could be perhaps some of the backups are going to the default backup folder "<<Installation Path>>"\MSSQL10.MSSQLSERVER\MSSQL\DATA" and others are going to a path you've specified?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1418916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse