hi everyBody, Can some one tell me the steps of how to make daily back up database from SQL Server 2008, when i do this Script and job it give me an error cant be completed, any help plz...
SaRa Ahmad 0 Junior Poster in Training
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
What script and what error?
anupamduttabd 0 Newbie Poster
Follow the following link to create MSSQL database backup.
http://duttanup.blogspot.com/2013/06/mssql-database-backup.html
M.Waqas Aslam 67 Posting Pro in Training Featured Poster
i found this query to create the backup of the system
BACKUP DATABASE [D:\testing.mdf] TO disk = 'C:\PathToBackup\BackupFileName.bak'
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.