Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



SQL Database backups

From: George (2011-11-23 13:00)

I've created a new maintenance plan to back up my database, but I want to point the destination folder to a drive on our network. When I hit the browse all I see are my 2 physical drives ('C' & 'D'.
I have my drives mapped and can see them in my computer.
Is there something I need to do in the SQL Server Management Studio to be able to see those other drives?
I just want to say Thank you to all for the help I've been receiving here lately. One day I will be able to return the help.
thx,
mrggutz


From: Victor (2011-11-23 14:44)

Hi George,
Please provide the version of SQL server you are using.
Is it 2000 or 2005 or 2008 ?
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> I've created a new maintenance plan to back up my database, but I want to point the destination folder to a drive on our network. When I hit the browse all I see are my 2 physical drives ('C' & 'D'.
> I have my drives mapped and can see them in my computer.
> Is there something I need to do in the SQL Server Management Studio to be able to see those other drives?
>
> I just want to say Thank you to all for the help I've been receiving here lately. One day I will be able to return the help.
>
> thx,
> mrggutz
>


From: Victor (2011-11-23 15:00)

Hi George,
I found some information about restoring and backing up from network drives, hope it helps you :
FOR RESTORING FROM NETWORK DRIVE :
OPTION 1 : Browse there manually using Windows Explorer and then cut&paste the path and backup name into the bottom text field of the dialog box that's showing you your folders. You cannot map a network drive in your windows session and have SQL Server use it as its running under a service account. I haven't tried but you could set SQL Server to log on using a specific user account and have that account have a mapped drive persistently mapped? Using a full UNC of the form \\computername\share\folders\file.bak is always going to be more reliable than a mapped drive letter.
Remember the network share the backup is being restored from has to be accessible to the user that is running the SQL server service - it is not enough to log on to the server console yourself and find the file.
OPTION 2 :
'restore database --> From Device --> File; click the 'ADD' Button-->
Get the FULL UNC path as "\\ComputerName\Shared folder\Backup\abc.Bak" by mapping in the
explore window.
Copy the path & paste this path under add button-->File Name. It will work.
For Back Ups to Network Drive :
OPTION 1 : Unfortunately, backup/restore wont work directly with a mapped network drive.
There are other ways to accomplish the same:
1) Directly type the UNC path of the server where you would like to backup /restore from [Eg: type \\servername\Sharename\Filename.bak in the 'Locate database files' dialog's 'File name' text box]
2) Create a backup device pointing to the UNC path. Then backup to this device.
OPTION 2 : If your SQL Server database is on a Cluster that does not see that local drive (probably because it is connected to the San box).
This situation will require you to use UNC naming as there is no guarantee that the local server will be the active server in the cluster. This basically mean that you will have to backup over the network even though this is a local drive because SQL Server does not see the local drive since it is not part of the cluster.
The next issue you will face is backing up over the network. Not a very good way to accomplish backups as SQL server is not very tolerate for small network hiccups that always occur.
The best way to do this is to backup to the cluster and then utilize windows cmd shell to move the file using UNC to the drive on the local machine to your target backup drive.
Remember, Clusters are very different from stand alone servers. The best way is to think of the cluster as it's own server as it is very independent of the nodes hosting it.
Hope this helps.
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi George,
>
> Please provide the version of SQL server you are using.
>
> Is it 2000 or 2005 or 2008 ?
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > I've created a new maintenance plan to back up my database, but I want to point the destination folder to a drive on our network. When I hit the browse all I see are my 2 physical drives ('C' & 'D'.
> > I have my drives mapped and can see them in my computer.
> > Is there something I need to do in the SQL Server Management Studio to be able to see those other drives?
> >
> > I just want to say Thank you to all for the help I've been receiving here lately. One day I will be able to return the help.
> >
> > thx,
> > mrggutz
> >
>


From: Victor (2011-11-23 15:03)

Hi George,
Also make sure that the Database Engine service account has access to the mapped network drive.
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi George,
>
> I found some information about restoring and backing up from network drives, hope it helps you :
>
> FOR RESTORING FROM NETWORK DRIVE :
> OPTION 1 : Browse there manually using Windows Explorer and then cut&paste the path and backup name into the bottom text field of the dialog box that's showing you your folders. You cannot map a network drive in your windows session and have SQL Server use it as its running under a service account. I haven't tried but you could set SQL Server to log on using a specific user account and have that account have a mapped drive persistently mapped? Using a full UNC of the form \\computername\share\folders\file.bak is always going to be more reliable than a mapped drive letter.
>
> Remember the network share the backup is being restored from has to be accessible to the user that is running the SQL server service - it is not enough to log on to the server console yourself and find the file.
>
> OPTION 2 :
> 'restore database --> From Device --> File; click the 'ADD' Button-->
> Get the FULL UNC path as "\\ComputerName\Shared folder\Backup\abc.Bak" by mapping in the
> explore window.
> Copy the path & paste this path under add button-->File Name. It will work.
>
> For Back Ups to Network Drive :
>
> OPTION 1 : Unfortunately, backup/restore wont work directly with a mapped network drive.
> There are other ways to accomplish the same:
> 1) Directly type the UNC path of the server where you would like to backup /restore from [Eg: type \\servername\Sharename\Filename.bak in the 'Locate database files' dialog's 'File name' text box]
> 2) Create a backup device pointing to the UNC path. Then backup to this device.
>
> OPTION 2 : If your SQL Server database is on a Cluster that does not see that local drive (probably because it is connected to the San box).
>
> This situation will require you to use UNC naming as there is no guarantee that the local server will be the active server in the cluster. This basically mean that you will have to backup over the network even though this is a local drive because SQL Server does not see the local drive since it is not part of the cluster.
>
> The next issue you will face is backing up over the network. Not a very good way to accomplish backups as SQL server is not very tolerate for small network hiccups that always occur.
>
> The best way to do this is to backup to the cluster and then utilize windows cmd shell to move the file using UNC to the drive on the local machine to your target backup drive.
>
> Remember, Clusters are very different from stand alone servers. The best way is to think of the cluster as it's own server as it is very independent of the nodes hosting it.
>
> Hope this helps.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Hi George,
> >
> > Please provide the version of SQL server you are using.
> >
> > Is it 2000 or 2005 or 2008 ?
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > I've created a new maintenance plan to back up my database, but I want to point the destination folder to a drive on our network. When I hit the browse all I see are my 2 physical drives ('C' & 'D'.
> > > I have my drives mapped and can see them in my computer.
> > > Is there something I need to do in the SQL Server Management Studio to be able to see those other drives?
> > >
> > > I just want to say Thank you to all for the help I've been receiving here lately. One day I will be able to return the help.
> > >
> > > thx,
> > > mrggutz
> > >
> >
>