network disk(SAN) for backup

Hello all,
Can I use network disk(SAN) to take a backup on a database?
I tested it, but it failed.
I use SQL Server 2000 and Windows Server 2000 and 2003.
Thanks in advance,
Do.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200510/1
Check out:
http://www.microsoft.com/technet/pro.../spltmirr.mspx
and
http://www.redbooks.ibm.com/abstracts/sg245470.html
HTH
Jerry
"Do Park via droptable.com" <u3287@.uwe> wrote in message
news:55d595770f944@.uwe...
> Hello all,
> Can I use network disk(SAN) to take a backup on a database?
> I tested it, but it failed.
> I use SQL Server 2000 and Windows Server 2000 and 2003.
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200510/1
|||How did you try? What was the error message?
Andrew J. Kelly SQL MVP
"Do Park via droptable.com" <u3287@.uwe> wrote in message
news:55d595770f944@.uwe...
> Hello all,
> Can I use network disk(SAN) to take a backup on a database?
> I tested it, but it failed.
> I use SQL Server 2000 and Windows Server 2000 and 2003.
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200510/1

network disk(SAN) for backup

Hello all,
Can I use network disk(SAN) to take a backup on a database?
I tested it, but it failed.
I use SQL Server 2000 and Windows Server 2000 and 2003.
Thanks in advance,
Do.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200510/1Check out:
http://www.microsoft.com/technet/pr...n/spltmirr.mspx
and
http://www.redbooks.ibm.com/abstracts/sg245470.html
HTH
Jerry
"Do Park via droptable.com" <u3287@.uwe> wrote in message
news:55d595770f944@.uwe...
> Hello all,
> Can I use network disk(SAN) to take a backup on a database?
> I tested it, but it failed.
> I use SQL Server 2000 and Windows Server 2000 and 2003.
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200510/1|||How did you try? What was the error message?
Andrew J. Kelly SQL MVP
"Do Park via droptable.com" <u3287@.uwe> wrote in message
news:55d595770f944@.uwe...
> Hello all,
> Can I use network disk(SAN) to take a backup on a database?
> I tested it, but it failed.
> I use SQL Server 2000 and Windows Server 2000 and 2003.
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200510/1

network disk(SAN) for backup

Hello all,
Can I use network disk(SAN) to take a backup on a database?
I tested it, but it failed.
I use SQL Server 2000 and Windows Server 2000 and 2003.
Thanks in advance,
Do.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1Check out:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/spltmirr.mspx
and
http://www.redbooks.ibm.com/abstracts/sg245470.html
HTH
Jerry
"Do Park via SQLMonster.com" <u3287@.uwe> wrote in message
news:55d595770f944@.uwe...
> Hello all,
> Can I use network disk(SAN) to take a backup on a database?
> I tested it, but it failed.
> I use SQL Server 2000 and Windows Server 2000 and 2003.
> Thanks in advance,
> Do.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1|||How did you try? What was the error message?
--
Andrew J. Kelly SQL MVP
"Do Park via SQLMonster.com" <u3287@.uwe> wrote in message
news:55d595770f944@.uwe...
> Hello all,
> Can I use network disk(SAN) to take a backup on a database?
> I tested it, but it failed.
> I use SQL Server 2000 and Windows Server 2000 and 2003.
> Thanks in advance,
> Do.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1sql

Network Backups SQL server 2005 Ent

I am trying to backup to a network drive. When I choose backup to disk it
will not show anything but my local drives. I put in a UNC or a mapped
drive and it says it cannot validate the existance of the backup directory.
My server has access to the shared drives on the other machines why can't
SQL server see it.
Is there something I have to turn on in SQL Server 2005 before it will let
me backup over the network?
Any idea's on why this is not working for me?
Hi
The Service Account that SQL Server runs under needs to be a domain account,
and must have permissions on the destination share. Same as for SQL Server
2000
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Unreal400" <Unreal400@.discussions.microsoft.com> wrote in message
news:E4BD6092-C082-4063-AFE8-3FAA866E8C75@.microsoft.com...
>I am trying to backup to a network drive. When I choose backup to disk it
> will not show anything but my local drives. I put in a UNC or a mapped
> drive and it says it cannot validate the existance of the backup
> directory.
> My server has access to the shared drives on the other machines why can't
> SQL server see it.
> Is there something I have to turn on in SQL Server 2005 before it will let
> me backup over the network?
> Any idea's on why this is not working for me?

Network Backups SQL server 2005 Ent

I am trying to backup to a network drive. When I choose backup to disk it
will not show anything but my local drives. I put in a UNC or a mapped
drive and it says it cannot validate the existance of the backup directory.
My server has access to the shared drives on the other machines why can't
SQL server see it.
Is there something I have to turn on in SQL Server 2005 before it will let
me backup over the network?
Any idea's on why this is not working for me?Hi
The Service Account that SQL Server runs under needs to be a domain account,
and must have permissions on the destination share. Same as for SQL Server
2000
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Unreal400" <Unreal400@.discussions.microsoft.com> wrote in message
news:E4BD6092-C082-4063-AFE8-3FAA866E8C75@.microsoft.com...
>I am trying to backup to a network drive. When I choose backup to disk it
> will not show anything but my local drives. I put in a UNC or a mapped
> drive and it says it cannot validate the existance of the backup
> directory.
> My server has access to the shared drives on the other machines why can't
> SQL server see it.
> Is there something I have to turn on in SQL Server 2005 before it will let
> me backup over the network?
> Any idea's on why this is not working for me?

Needs to put quotes around numeric data in export text file

Hi
- I'm trying to export the data from crystal report to a disk file in a CS/ tab seperated format.
-The export file contains quotes around text fileds
- Is there any way to get quotes around numerical data?
Thanks in Advance :)
Bashayou need to have that in report itself
Create formula and write code
""""+Cstr({Field})+""""