Home Forums SQL Server 2008 SQL Server 2008 - General Error while taking backup for a user not having sysadmin permission RE: Error while taking backup for a user not having sysadmin permission

  • May 2, 2013 at 4:02 am

    #1611832

    Hi,

    On the printscreen with the error message you don't have a filename entered by "Destination on disk". You do have specified a folder, but if you don't add a filename the backup filename will be the same as the foldername. You can't have a file with the same name as a folder (within the same parent folder).

    This folder exists on your machine:

    ..\MSSQL10.SQLEXPRESS\MSSQL\BackupSo you can not create a file with name:

    ..\MSSQL10.SQLEXPRESS\MSSQL\Backup

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **