If Err.Number >= 0 Then
BackUpDatabase = True
BackUpDatabase = False
MsgBox "Error Occured : " & Err.Description & " " & Err.Number
: the problem is I cant find the .bak file on the drive specified. the backup is successfull as per message and the process took around 1-2 min after it gives out the message.
: the server is on the network. SQL Server 2005 and it is installed on Microsoft Windows Server 2003.