Hello,
I want to know how you backup your databases because i have the following problem :
I am doing a backup every day with 1 days of retention, but i haven't got any places on my server.
How can i put the backup on another server ( SAN for instance) ?Hello,
I want to know how you backup your databases because i have the following problem :
I am doing a backup every day with 1 days of retention, but i haven't got any places on my server.
How can i put the backup on another server ( SAN for instance) ?
If I understand your question correctly, you have run out of space to store backups on your database server. You are trying to figure out a way to write the backups to a network device (such as Network Attached Storage (NAS) or another server).
Correct?
If so, you can use UNC naming conventions to write the backups to another network device. Such as: \\MyServer\MyShare\SQL_BACKUPS.
Regards,
hmscott|||Note the big IF in the next sentence.
IF you start the Windows Service that runs Microsoft SQL Server using a domain account (instead of localsystem), then you can backup to any UNC filename that that domain account can access.
-PatP|||Note the big IF in the next sentence.
IF you start the Windows Service that runs Microsoft SQL Server using a domain account (instead of localsystem), then you can backup to any UNC filename that that domain account can access.
-PatP
[embarrassed look]
yes; I should have mentioned that
[/embarrassed look]
I should note, however, that it may be a bit different with a NAS, depending on the vendor and NAS OS. The only way we could write to our NAS was to map a drive, and then leave the server logged in (with the screen locked).|||when i put a unc path to the maintenance plan, there is an error.
It tells me that this path is invalid.|||when i put a unc path to the maintenance plan, there is an error.
It tells me that this path is invalid.
It means that:
1. The UNC path is specified incorrectly (copy and paste from a Explorer address bar to eliminate this possibility.
2. (More likely) There is a permissions issue as described by Pat. Verify that your SQL Service is running under a DOMAIN account and that the user has permissions to the folder you wish to write to.
3. (Possibly, if you are using a NAS) If you are using a NAS that is not "domain aware" you may have to do things differently (like mapping a drive).
Regards,
hmscott|||when i doing this i have the following message
"The backup directory is invalid. Are you sure this is what you want ?"
How are you doing ?|||Listen, the best advice we should be giving you is to clear off some space, dump to the local drive, zip it, and robocopy the file to another server.
How big is your database, and how bug is the current drive?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment