Eprs_Admin
asked on
cannot make SQL DB backup to disk
Hi Experts,
I want to make a backup of my DB to DISK.
The SQL Server is 2008 on WIN 2008.
I have a share on another server to pu the backup there. The folder is shared vor everyone.
But the backup with the GUI is not working.
Can you help me please ?
I want to make a backup of my DB to DISK.
The SQL Server is 2008 on WIN 2008.
I have a share on another server to pu the backup there. The folder is shared vor everyone.
But the backup with the GUI is not working.
Can you help me please ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do you mean "it isn't working in the gui"? Do you get error messages?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The permission is set to everyone and full.
The security the same.
The error is in german.
Is it possible to make a backup to another server in a share with management Studio ?
The security the same.
The error is in german.
Is it possible to make a backup to another server in a share with management Studio ?
Screenshot of the error would help.
ASKER
Now used the script, ans the backup was successful to a shared folder \\server\sql\
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok let me check this...
ASKER
the backup via script, is it a full backup of the DB ?
I have to make a full backup, which I can restore easily with the Management Studio GUI.
I have to make a full backup, which I can restore easily with the Management Studio GUI.
ASKER
My test DB is 92GB and the script just backed up 15GB.
Something is wrong here.
Can you show me what ?
Something is wrong here.
Can you show me what ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The SQL Agent user belongs to domain-admins group and should have enough rights in the domain.
ASKER
Yes it is a ENterprise version in a cluster. :-)
Just for my understanding, can you explain the command in detail ?
BACKUP DATABASE @db TO DISK = @pathandfile
WITH NOFORMAT, INIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 5
Just for my understanding, can you explain the command in detail ?
BACKUP DATABASE @db TO DISK = @pathandfile
WITH NOFORMAT, INIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 5
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok now it works also from the GUI.
The problem wasn´t the share. It was the backup file name and then I pressed browse.
But the file was not created yet and there the error poped up, but when I just click ok, the backup starts.
Sorry for that.
The problem wasn´t the share. It was the backup file name and then I pressed browse.
But the file was not created yet and there the error poped up, but when I just click ok, the backup starts.
Sorry for that.