Can't backup Remote database

I am using the SQL express manager to try to backup a remote database
and it tells me the path for the backup is no good, but it will not
let me change it, any ideas.
Rick
hi Rick,
Rick wrote:
> I am using the SQL express manager to try to backup a remote database
> and it tells me the path for the backup is no good, but it will not
> let me change it, any ideas.
>
try using SQL Server Management Studio Express you can download from
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e,
instead of SQLExpress Manager..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Jun 15, 12:59 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi Rick,
> Rick wrote:
> try using SQL Server Management Studio Express you can download fromhttp://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...,
> instead of SQLExpress Manager..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
I tried that with same results, If I remove the backup device and try
to add another one, I get the error Property Backupdirectory is not
available for settings "microsoft.sqlserver.management.smo.settings"
Rick
|||hi Rick,
Rick wrote:
> I tried that with same results, If I remove the backup device and try
> to add another one, I get the error Property Backupdirectory is not
> available for settings "microsoft.sqlserver.management.smo.settings"
>
please verify the account running SQLExpress has enought permissions on the
backup device at the NTFS file system level as well..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Jun 15, 3:40 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi Rick,
> Rick wrote:
> please verify the account running SQLExpress has enought permissions on the
> backup device at the NTFS file system level as well..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
i had to add a backupDevice key on the sqlserver pointing to c:, that
solved the problem
thanks
Rick

Cannot retrieve data in utf-8 from php

Hi.

I have a IIS server with php3 installed. I have SQL server database
and data stored in unicode format (nvarchar fields). In header of my
php I have the meta: <meta HTTP-EQUIV="content-type"
CONTENT="text/html; charset=UTF-8">.

I have the following problem:

- I trie to do a query using ODBC (version 3.525.1022.0) and SQL
Server odbc driver (version 200.85.1022.00). The query doesn't
retrieve information in utf format and accents and extra characters
aren't showed correctly.

- I trie to di the query usin native OLE DB. I use mssql funtions and
the problem is the same.

If I install php4 and I use "new
COM("ADODB.Connection",NULL,CP_UTF8);", then it works correctly.

Anybody knows if its posible to retrieve data from sql-server in utf-8
format using php3?

I see in other postings that odbc driver only accept utf-8 in version
3.7 or higher? Is it true? If is true, where I can download odbc
driver 3.7?

Thank's in advance.
Miki.Miki (miquelpl2@.hotmail.com) writes:
> I see in other postings that odbc driver only accept utf-8 in version
> 3.7 or higher? Is it true? If is true, where I can download odbc
> driver 3.7?

First, as far as I know, the ODBC driver for SQL Server does not handle
UTF-8 at all, since SQL Server does not support UTF-8, but stores
all Unicode data as UCS-2. See http://support.microsoft.com/?id=232580.

ODBC is part of the MDAC, and with any recently new Windows machine,
you have an MDAC version which includes ODBC 3.7 or later. If you have
some old NT4 platform, you may have to look for something news.

Go to http://www.microsoft.com/downloads/...?displaylang=en,
and pick MDAC. You will have to check the versions that they support
your OS.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp