SQL BACKUPS
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
SQL BACKUPS
Hey Peeps.
I need some help regarding SQL backups. WE installed an INtel Baxter creek storage system for a client. IT's a little server box with 4x500GIG SATA II drives.
I mapped a network drive to a folder I created on this storage system.
I can browse to it normally, create folders etc... SO for normal windows use its 100%
BUT. I can't find a way to backup my SQL databases to the said network drive. IF You take this route, righclick on the database --> All tasks --> Backup Database, you get to the backup screen.
But my only options when adding a new backup here, are to local drives.Only the Server's C and D drives are present and not the Mapped Z: Drive. IF I try and browse to the location by entering z:\ manually it says "SQL cannot connect to the drive(bla bla)..........."
IF you browse backup locations/destinations, as many of you would no, it does not display a folder tree, only the local drives.
No network drive.
Any help on this please!??!?!?!?!?
I need some help regarding SQL backups. WE installed an INtel Baxter creek storage system for a client. IT's a little server box with 4x500GIG SATA II drives.
I mapped a network drive to a folder I created on this storage system.
I can browse to it normally, create folders etc... SO for normal windows use its 100%
BUT. I can't find a way to backup my SQL databases to the said network drive. IF You take this route, righclick on the database --> All tasks --> Backup Database, you get to the backup screen.
But my only options when adding a new backup here, are to local drives.Only the Server's C and D drives are present and not the Mapped Z: Drive. IF I try and browse to the location by entering z:\ manually it says "SQL cannot connect to the drive(bla bla)..........."
IF you browse backup locations/destinations, as many of you would no, it does not display a folder tree, only the local drives.
No network drive.
Any help on this please!??!?!?!?!?
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
it probably requires the resolved path, not the 'masked' entry provided by explorer.. (the "mapping" just displays a more user-friendly id...).
have you tried
??
have you tried
Code: Select all
\\server\shared_folder\
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
UM, LOL! YEAH MAN.
THE Administrator on the account has full privelages everywhere.
AND as mentioned before, if you browese to that directory from Start--> Run, or using hte Z: drive, you immideatly have full access.
I created various test folders to check, I tried connecting there using IpAdress\share, Mapdrive and pcname\Share, still nothing.
I included screenshots to show you the setup, and the error....
![Image](http://img2.freeimagehosting.net/uploads/th.c99513cb76.jpg)
![Image](http://img2.freeimagehosting.net/uploads/th.7371b9d009.jpg)
![Image](http://img2.freeimagehosting.net/uploads/th.74021b5870.jpg)
THE Administrator on the account has full privelages everywhere.
AND as mentioned before, if you browese to that directory from Start--> Run, or using hte Z: drive, you immideatly have full access.
I created various test folders to check, I tried connecting there using IpAdress\share, Mapdrive and pcname\Share, still nothing.
I included screenshots to show you the setup, and the error....
![Image](http://img2.freeimagehosting.net/uploads/th.c99513cb76.jpg)
![Image](http://img2.freeimagehosting.net/uploads/th.7371b9d009.jpg)
![Image](http://img2.freeimagehosting.net/uploads/th.74021b5870.jpg)
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
odd..
have you tried specifying a file?
also, i know its internal.. still, blot that ip in pic1... ![Twisted Evil :twisted:](./images/smilies/icon_twisted.gif)
have you tried specifying a file?
Code: Select all
\\server\folder\backup.bak
![Twisted Evil :twisted:](./images/smilies/icon_twisted.gif)
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
this points to an issue with the management app... we run several different sql management tools here, accessing seven servers, and roughly as many shares, none of which present with this.. only the one requires a resolved path...
nothing under support for this type of issue?... 8O
<feels vaguely useless in the face of overwhelming oddity... >
nothing under support for this type of issue?... 8O
<feels vaguely useless in the face of overwhelming oddity... >
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
-
- Moderator Emeritus
- Posts: 1632
- Joined: 14 May 2003, 02:00
- Location: Durban
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
I was thinking about going that route, but THe client (and the Database developer, whom himself cant get the backups going) Demands it to be done this way, cause its part of hte software security policy that they drew up.
so I HAVE TO DO IT THIS WAY.
PLus the fact that normally copying it in windows, while users are logged into the DB will cause it to crash the copying/backup....
ANd the database is over 100GIG's big, so its not something htat's just gonna take 3 minutes........
so I HAVE TO DO IT THIS WAY.
PLus the fact that normally copying it in windows, while users are logged into the DB will cause it to crash the copying/backup....
ANd the database is over 100GIG's big, so its not something htat's just gonna take 3 minutes........
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
I tried to create a backupset (and backing up normally) like this:viceroy wrote:how EXACTLY did you do it?
\\192.168.0.205\Public\backups\SQL (with and without a slash at the end)
and
z:\ (Drive Z I mapped to the full path, but what I also did was only map it to the public folder, to test, so with that I went)
z:\backups\SQL (again with and without a slash at the end)
I also tried
\\backupserver\public\backups\SQL
ANd through each and every setp I did the same thing via windows and again, I have FULL access to Z:
I have (or had when I did it) full access to z:\public
I have full access to 192.168.0.205\ and to every foler inside
Cause the server has 4 HDD drives, I tried mapping, and jsut plain sharing the drives and folder in them independantly, also get hung up on the same problem..........
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
viceroy wrote:Creating the backup device.viceroy wrote:how EXACTLY did you do it?
Also...Are you SURE the account doing the backups has permissions to the shared folder?
YEah man, The Administrator account has FULL PRIVELAGES EVERYWHERE, read the post above......
I did try, just for interest sakes to to use another power/superuser with full access to do it, and got the smae issue.
Last edited by Maplassie_GTR on 03 Apr 2007, 12:15, edited 1 time in total.
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
Yebo I did......viceroy wrote:Okay, thats fine...but did you create a Backup Device like I suggested? It doesn't seem like if from your description
And you haven't specified the file to use for the backup...do it!
This is what I did there.......
![Image](http://img2.freeimagehosting.net/uploads/783ca52ab6.jpg)
NOw here is the path.
Again, I tried, Name, IP and mapped drive, and even different folders (wich do exist and I have full access to)
IF you click the ... (browse button) only the 2 local drives of the machine appear.....
![Image](http://img2.freeimagehosting.net/uploads/21215766e8.jpg)
![Image](http://img2.freeimagehosting.net/uploads/dbf9d737e7.jpg)
I did specify file aswell, I called it 100 backup.bak.......
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
bet you 50 cheese cubes the errorlog reports authentication issues... try replicating the user on the backup/share server directly, (bypassing share replication)....
could be the management app is not using the windows authentication service correctly, which could be the root of the issue...
this is a first and i'm dying to see the cause![Idea :idea:](./images/smilies/icon_idea.gif)
could be the management app is not using the windows authentication service correctly, which could be the root of the issue...
this is a first and i'm dying to see the cause
![Idea :idea:](./images/smilies/icon_idea.gif)
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Wow... I was thinking that whole thing as well rusty... (No, this is seriously honest...)
I am also thinking that SQL does not check for user access according to the windows setup, but works on a SQL login basis. Thus, you would not be allowed to access the mapped drive then...
I am also thinking that SQL does not check for user access according to the windows setup, but works on a SQL login basis. Thus, you would not be allowed to access the mapped drive then...
My BF2142 Stats:
![Image](http://sigs.2142-stats.com/SlasherZA_player_7689.png)
Slasher : Former member of www.PCFormat.co.za
I have reached the end of my near 5 year forum life. Farewell good days...
slasher (at) webmail (dot) co (dot) za
![Image](http://sigs.2142-stats.com/SlasherZA_player_7689.png)
Slasher : Former member of www.PCFormat.co.za
I have reached the end of my near 5 year forum life. Farewell good days...
slasher (at) webmail (dot) co (dot) za
SQL does allow windows and domain accounts to access it if using mixed mode authSlasher wrote:Wow... I was thinking that whole thing as well rusty... (No, this is seriously honest...)
I am also thinking that SQL does not check for user access according to the windows setup, but works on a SQL login basis. Thus, you would not be allowed to access the mapped drive then...
-
- Registered User
- Posts: 9734
- Joined: 07 Oct 2004, 02:00
- Contact:
WEll Um. You would not believe that I am still struggling with the issue.
Thing is I even got hold of a buddie's buddie, who is really awesomely trained in the arts of SQL, and not even he could get it right. its very strange.
I opted to go the long route, by copying it to a local HDD, then copying to the backup device afterwards. Takes uber long, but it works so........
ANyhoo, shot for hte help and the input!
Cheers peeps![Exclamation :!:](./images/smilies/icon_exclaim.gif)
Thing is I even got hold of a buddie's buddie, who is really awesomely trained in the arts of SQL, and not even he could get it right. its very strange.
I opted to go the long route, by copying it to a local HDD, then copying to the backup device afterwards. Takes uber long, but it works so........
ANyhoo, shot for hte help and the input!
Cheers peeps
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
![Image](http://i8.photobucket.com/albums/a45/maplassie/ztune1sig12.jpg)