Database Names

Hi Everyone,
I've got Windows SharePoint Services installed and it uses a database called
STS_svr-apps-1_1414639615
I'm trying to back up this database from the QSQL command line tool.
However when I try to run the backup, I get the following error:
1> BACKUP DATABASE STS_svr-apps-1_1414639615 TO DISK
'D:\ShareBack\Backup.bak'
2> GO
Msg 170, Level 15, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Line 1: Incorrect syntax near '-'.
1>
Thinking it might be an issue with the name I enclosed it in single quotes:
1> BACKUP DATABASE 'STS_svr-apps-1_1414639615' TO DISK
'D:\ShareBack\Backup.bak'
2> GO
Msg 170, Level 15, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Line 1: Incorrect syntax near 'STS_svr-apps-1_1414639615'.
1>
Yet I still get the same error!
Then I tried to just use the database:
1> use STS_svr-apps-1_1414639615
2> go
Msg 911, Level 16, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Could not locate entry in sysdatabases for database 'STS_svr'. No entry
found
with that name. Make sure that the name is entered correctly.
1>
Again I tried to using quotation marks, another error:
1> use 'STS_svr-apps-1_1414639615'
2> GO
Msg 170, Level 15, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Line 1: Incorrect syntax near 'STS_svr-apps-1_1414639615'.
1> quit
If I do:
SELECT name
FROM master..sysdatabases
ORDER BY name
It lists:
master
model
msdb
STS_Config
STS_svr-apps-1_1414639615
tempdb
From this I can only assume MSDE doesn't support having '-' in a database
name?
Can someone suggest a way around this?
Thanks
Chris Moon
hi Chris,
> From this I can only assume MSDE doesn't support having '-' in a
> database name?
>
SQL Server (and MSDE) support this kind of identifier.. executing
SET NOCOUNT ON
SELECT @.@.VERSION
GO
CREATE DATABASE [STS_svr-apps-1_1414639615];
GO
USE [STS_svr-apps-1_1414639615];
GO
USE master ;
GO
DROP DATABASE [STS_svr-apps-1_1414639615];
reports
Microsoft SQL Server 2000 - 8.00.2162 (Intel X86)
Sep 30 2005 19:59:14
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
The CREATE DATABASE process is allocating 0.75 MB on disk
'STS_svr-apps-1_1414639615'.
The CREATE DATABASE process is allocating 0.49 MB on disk
'STS_svr-apps-1_1414639615_log'.
Deleting database file 'C:\Programmi\Microsoft SQL
Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615_log.LDF'.
Deleting database file 'C:\Programmi\Microsoft SQL
Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615.mdf'.
http://msdn.microsoft.com/library/de...on_03_6e9e.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Many thanks Andrea, it worked perfectly.
Thanks again.
Chris Moon
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:43ml8mF1o772rU1@.individual.net...
> hi Chris,
> SQL Server (and MSDE) support this kind of identifier.. executing
> SET NOCOUNT ON
> SELECT @.@.VERSION
> GO
> CREATE DATABASE [STS_svr-apps-1_1414639615];
> GO
> USE [STS_svr-apps-1_1414639615];
> GO
> USE master ;
> GO
> DROP DATABASE [STS_svr-apps-1_1414639615];
> reports
> ----
> Microsoft SQL Server 2000 - 8.00.2162 (Intel X86)
> Sep 30 2005 19:59:14
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> The CREATE DATABASE process is allocating 0.75 MB on disk
> 'STS_svr-apps-1_1414639615'.
> The CREATE DATABASE process is allocating 0.49 MB on disk
> 'STS_svr-apps-1_1414639615_log'.
> Deleting database file 'C:\Programmi\Microsoft SQL
> Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615_log.LDF'.
> Deleting database file 'C:\Programmi\Microsoft SQL
> Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615.mdf'.
> http://msdn.microsoft.com/library/de...on_03_6e9e.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql

Database Move

Hi
I am doing a test database migration for SQL Reporting Services (leaving
the front end as it is). I have successfully moved the database using
http://support.microsoft.com/?kbid=842425 as ref guide. I have also moved
the databases that the reports uses to collect data from. I have updated
the data source icon for the reports to point to new database location.
When i want to view the reports i now get the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection
Have i missed a step to get this working (there is no mention on KB842425
about security settings)?
Your help will be appreciated.
--
Regards
James[MVP for MBS Great Plains]
Visit MBS Blog Central
http://mbscentral.blogs.comDoes SQL Reporting Services Datasource support named instanced server names?
--
Regards
James[MVP]
Visit MBS Blog Central
http://mbscentral.blogs.com
"James[MVP]" <hushdontspamme@.Hotmail.com> wrote in message
news:ONGULWCRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am doing a test database migration for SQL Reporting Services (leaving
> the front end as it is). I have successfully moved the database using
> http://support.microsoft.com/?kbid=842425 as ref guide. I have also
> moved the databases that the reports uses to collect data from. I have
> updated the data source icon for the reports to point to new database
> location.
> When i want to view the reports i now get the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection
> Have i missed a step to get this working (there is no mention on KB842425
> about security settings)?
> Your help will be appreciated.
> --
> Regards
> James[MVP for MBS Great Plains]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
>|||Yes.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
news:efJ0hmCRFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Does SQL Reporting Services Datasource support named instanced server
> names?
> --
> Regards
> James[MVP]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
> "James[MVP]" <hushdontspamme@.Hotmail.com> wrote in message
> news:ONGULWCRFHA.2744@.TK2MSFTNGP10.phx.gbl...
>> Hi
>> I am doing a test database migration for SQL Reporting Services (leaving
>> the front end as it is). I have successfully moved the database using
>> http://support.microsoft.com/?kbid=842425 as ref guide. I have also
>> moved the databases that the reports uses to collect data from. I have
>> updated the data source icon for the reports to point to new database
>> location.
>> When i want to view the reports i now get the following error:
>> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>> Server connection
>> Have i missed a step to get this working (there is no mention on
>> KB842425 about security settings)?
>> Your help will be appreciated.
>> --
>> Regards
>> James[MVP for MBS Great Plains]
>> Visit MBS Blog Central
>> http://mbscentral.blogs.com
>|||If SQL Server remains on a second machine, the SQL Server must handle
delegation.
http://pluralsight.com/blogs/keith/archive/2004/07/08/1586.aspx
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
news:ONGULWCRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am doing a test database migration for SQL Reporting Services (leaving
> the front end as it is). I have successfully moved the database using
> http://support.microsoft.com/?kbid=842425 as ref guide. I have also
> moved the databases that the reports uses to collect data from. I have
> updated the data source icon for the reports to point to new database
> location.
> When i want to view the reports i now get the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection
> Have i missed a step to get this working (there is no mention on KB842425
> about security settings)?
> Your help will be appreciated.
> --
> Regards
> James[MVP for MBS Great Plains]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
>

database maintenance plan

i currently am using: sharepoint portal 2003 / windows sharepoint
services with sp2 and sql 2000 with sp4.
i'm trying to develop a database maintenance plan in sql 2000. so far,
to get past the
QUOTED_IDENTIFIER, i've added -SupportComputedColumn to the T-SQL code
in the steps, but since sharepoint actively keeps a connection to the
database, i'm unable to backup the transaction logs.
i tried adding something like this:
use master
go
alter database db1_prod set single_user with rollback immediate
go
...and it didn't work. anyone have a better idea?
thanks!> but since sharepoint actively keeps a connection to the
> database, i'm unable to backup the transaction logs.
Backup log is perfectly possible while users are connected to the database. My guess is that your
integrity check has the "attempt to repair minor problems" checked. This is a bad option in the
first place. I suggest you remove that option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<eric.olson@.gmail.com> wrote in message
news:1164121998.074547.209600@.f16g2000cwb.googlegroups.com...
>i currently am using: sharepoint portal 2003 / windows sharepoint
> services with sp2 and sql 2000 with sp4.
> i'm trying to develop a database maintenance plan in sql 2000. so far,
> to get past the
> QUOTED_IDENTIFIER, i've added -SupportComputedColumn to the T-SQL code
> in the steps, but since sharepoint actively keeps a connection to the
> database, i'm unable to backup the transaction logs.
> i tried adding something like this:
> use master
> go
> alter database db1_prod set single_user with rollback immediate
> go
> ...and it didn't work. anyone have a better idea?
> thanks!
>|||Regarding the statement:
"but since sharepoint actively keeps a connection to the
database, i'm unable to backup the transaction logs."
You can do database and log backups while the database is in use. You
don't need to drop any connections to perform the backup.
-Sue
On 21 Nov 2006 07:13:18 -0800, eric.olson@.gmail.com wrote:
>i currently am using: sharepoint portal 2003 / windows sharepoint
>services with sp2 and sql 2000 with sp4.
>i'm trying to develop a database maintenance plan in sql 2000. so far,
>to get past the
>QUOTED_IDENTIFIER, i've added -SupportComputedColumn to the T-SQL code
>in the steps, but since sharepoint actively keeps a connection to the
>database, i'm unable to backup the transaction logs.
>i tried adding something like this:
>use master
>go
>alter database db1_prod set single_user with rollback immediate
>go
>...and it didn't work. anyone have a better idea?
>thanks!|||where i'm at now:
Backup cannot be performed on database 'master'. The sub task is
ignored.
Backup cannot be performed on database 'msdb'. The sub task is ignored.
Sue Hoegemeier wrote:
> Regarding the statement:
> "but since sharepoint actively keeps a connection to the
> database, i'm unable to backup the transaction logs."
> You can do database and log backups while the database is in use. You
> don't need to drop any connections to perform the backup.
> -Sue
> On 21 Nov 2006 07:13:18 -0800, eric.olson@.gmail.com wrote:
> >i currently am using: sharepoint portal 2003 / windows sharepoint
> >services with sp2 and sql 2000 with sp4.
> >
> >i'm trying to develop a database maintenance plan in sql 2000. so far,
> >to get past the
> >QUOTED_IDENTIFIER, i've added -SupportComputedColumn to the T-SQL code
> >in the steps, but since sharepoint actively keeps a connection to the
> >database, i'm unable to backup the transaction logs.
> >
> >i tried adding something like this:
> >
> >use master
> >go
> >alter database db1_prod set single_user with rollback immediate
> >go
> >
> >...and it didn't work. anyone have a better idea?
> >
> >thanks!|||eric.olson@.gmail.com wrote:
> where i'm at now:
> Backup cannot be performed on database 'master'. The sub task is
> ignored.
> Backup cannot be performed on database 'msdb'. The sub task is ignored.
That means you're attempting to do a transaction log backup on those
databases, and they're in Simple recovery mode. You can't backup the
t-log on a Simple mode database.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||i took off the 'attempt to repair minor problems' but still get errors
with the master and msdb databases backup. perhaps i need to make a
separate database maintenance plan for those two, and only have them
backup and not touch the transaction logs?
Tibor Karaszi wrote:
> > but since sharepoint actively keeps a connection to the
> > database, i'm unable to backup the transaction logs.
> Backup log is perfectly possible while users are connected to the database. My guess is that your
> integrity check has the "attempt to repair minor problems" checked. This is a bad option in the
> first place. I suggest you remove that option.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <eric.olson@.gmail.com> wrote in message
> news:1164121998.074547.209600@.f16g2000cwb.googlegroups.com...
> >i currently am using: sharepoint portal 2003 / windows sharepoint
> > services with sp2 and sql 2000 with sp4.
> >
> > i'm trying to develop a database maintenance plan in sql 2000. so far,
> > to get past the
> > QUOTED_IDENTIFIER, i've added -SupportComputedColumn to the T-SQL code
> > in the steps, but since sharepoint actively keeps a connection to the
> > database, i'm unable to backup the transaction logs.
> >
> > i tried adding something like this:
> >
> > use master
> > go
> > alter database db1_prod set single_user with rollback immediate
> > go
> >
> > ...and it didn't work. anyone have a better idea?
> >
> > thanks!
> >|||right... but a microsoft article also said not to put master or msdb
in full mode.
should i put it in full recovery mode?
Tracy McKibben wrote:
> eric.olson@.gmail.com wrote:
> > where i'm at now:
> >
> > Backup cannot be performed on database 'master'. The sub task is
> > ignored.
> > Backup cannot be performed on database 'msdb'. The sub task is ignored.
> That means you're attempting to do a transaction log backup on those
> databases, and they're in Simple recovery mode. You can't backup the
> t-log on a Simple mode database.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||eric.olson@.gmail.com wrote:
> right... but a microsoft article also said not to put master or msdb
> in full mode.
> should i put it in full recovery mode?
>
No, just don't include those databases in the transaction log backup
job. Create two plans - one for system DB's, one for user DB's.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||that's exactly what i ended up doing :).
- plan1 - backup user databases w/transaction logs, database
optimization, and error checking
- plan2 - backup system databases and check for errors
thanks.
Tracy McKibben wrote:
> eric.olson@.gmail.com wrote:
> > right... but a microsoft article also said not to put master or msdb
> > in full mode.
> >
> > should i put it in full recovery mode?
> >
> No, just don't include those databases in the transaction log backup
> job. Create two plans - one for system DB's, one for user DB's.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com