Basic question

I've instaled M Visual Web Developer studio 2005 ee and SQL 2005.
Service is working, but i can't connect my project with serwer. ASP configuration tool(security) can't connect. Error message doesn't show any reason.
Server menager can connect normally.
Please help
what is the error message?sql

Basic question

I've instaled M Visual Web Developer studio 2005 ee and SQL 2005.
Service is working, but i can't connect my project with serwer. ASP configuration tool(security) can't connect. Error message doesn't show any reason.
Server menager can connect normally.
Please help
what is the error message?

Basic DTS service problems, i guess...

I try to access a remote SP.
Server1 has a working DTS-service running
Server2 cannot start the DTS due to the following error:
"An error 1060 - (the specified service does not exist as an installes service) occured while performing this service operation on the MSDTC service".

Ok, I got it, the service isn't running (since I get this mess. when I'm tryin to start the service).
Can't find any service in the opsys services. Tried to reinstall the MSSQL but the MSDTC was/is allready installed.

Please help!
By the way, I'm running MSSQL 2000.

thanksIs the dtc service started ?|||Originally posted by rnealejr
Is the dtc service started ?

Nope, and that's the problem. I get the errormessage when I try to start the service in enterprise manager.
I can't find any corresponding service in the opsys services. It seems like the service isn't installed...but it is??!!

Bad print performance on HP Laserjet?

Hi,

I've finished working on reports (RS2000) and tested them on several printers, mostly OKI printers, which worked perfectly.

I've deployed these reports and now I'm getting calls from the customer that these reports are not good when performed on a HP Laserjet 2100:

- The print is processed very slow
- The text versus grid is not good aligned
- Every time a print job is submitted there has to be pressed on the button of the printer

I've suggested trying to install an other driver (PostScript, PCL 5.0, ...), but that didn't helped.

Is this a known bug? Is there a workaround here? Thank you.

As a follow-up: this problem was solved when I visited the customer and tried another printer driver in Windows XP.

So case closed

Bad print performance on HP Laserjet?

Hi,

I've finished working on reports (RS2000) and tested them on several printers, mostly OKI printers, which worked perfectly.

I've deployed these reports and now I'm getting calls from the customer that these reports are not good when performed on a HP Laserjet 2100:

- The print is processed very slow
- The text versus grid is not good aligned
- Every time a print job is submitted there has to be pressed on the button of the printer

I've suggested trying to install an other driver (PostScript, PCL 5.0, ...), but that didn't helped.

Is this a known bug? Is there a workaround here? Thank you.

As a follow-up: this problem was solved when I visited the customer and tried another printer driver in Windows XP.

So case closed

bad performance, help needed

Hi,
We have a working application that has been ok for some time but recently as
our data and users increased we started to get timeouts as some queries
take more than minute to execute. This happens only occasionally on a very
specific query that joins couple of big tables.
Now the queries are fairly complex and unoptimized but that is not what
bothers me. (also changing queries didn't help, may be something to do with
amounts of data involved?)
If I run the same query as SA it runs in a second. If I run it as a normal
user that has been given select permissions on the relevant tables it takes
ages. Are there any settings for normal users regarding limits on resource
or something like that?
We only support two users SA and TheUser as authentication is done server
side and everything is done through stored procedures spare the read
queries. TheUser is granted permissions to read some tables and to execute
the stored procedures nothing else.
Using the SQL Trace thing... I can see that the offending query does approx
350000 reads and 20 writes. I don't know what that means but thought it
might help you help me ;)
Thank you,
YordanIt is impossible to say without actually seeing the query and the DDL for
the tables involved but it sounds liek it is not using an index and scanning
the table at least once, probably more. Can you post the other info?
Andrew J. Kelly SQL MVP
"Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
> Hi,
> We have a working application that has been ok for some time but recently
> as our data and users increased we started to get timeouts as some
> queries take more than minute to execute. This happens only occasionally
> on a very specific query that joins couple of big tables.
> Now the queries are fairly complex and unoptimized but that is not what
> bothers me. (also changing queries didn't help, may be something to do
> with amounts of data involved?)
> If I run the same query as SA it runs in a second. If I run it as a normal
> user that has been given select permissions on the relevant tables it
> takes ages. Are there any settings for normal users regarding limits on
> resource or something like that?
> We only support two users SA and TheUser as authentication is done server
> side and everything is done through stored procedures spare the read
> queries. TheUser is granted permissions to read some tables and to execute
> the stored procedures nothing else.
> Using the SQL Trace thing... I can see that the offending query does
> approx 350000 reads and 20 writes. I don't know what that means but
> thought it might help you help me ;)
> Thank you,
> Yordan
>
>|||Yordan,
Are you logging into Query Analyzer using SA and TheUser to make the
comparisons in time? Same T-SQL code? Are there any differences in the
execution plans chosen?
HTH
Jerry
"Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
> Hi,
> We have a working application that has been ok for some time but recently
> as our data and users increased we started to get timeouts as some
> queries take more than minute to execute. This happens only occasionally
> on a very specific query that joins couple of big tables.
> Now the queries are fairly complex and unoptimized but that is not what
> bothers me. (also changing queries didn't help, may be something to do
> with amounts of data involved?)
> If I run the same query as SA it runs in a second. If I run it as a normal
> user that has been given select permissions on the relevant tables it
> takes ages. Are there any settings for normal users regarding limits on
> resource or something like that?
> We only support two users SA and TheUser as authentication is done server
> side and everything is done through stored procedures spare the read
> queries. TheUser is granted permissions to read some tables and to execute
> the stored procedures nothing else.
> Using the SQL Trace thing... I can see that the offending query does
> approx 350000 reads and 20 writes. I don't know what that means but
> thought it might help you help me ;)
> Thank you,
> Yordan
>
>|||If timeouts occur "only occasionally", then perhaps your problem is with
blocking:
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/defaul...kb;EN-US;224453
Use SQL Server Profiler to verify that your SP is making good use of
indexes. Also, as your table gets larger, fragmentation may become an issue
that needs periodic maintenance.
How To: Use SQL Profiler
http://msdn.microsoft.com/library/d...
ethowto15.asp
Planning and Creating Indexes
http://www.microsoft.com/technet/pr...s/c0618260.mspx
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
"Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
> Hi,
> We have a working application that has been ok for some time but recently
> as our data and users increased we started to get timeouts as some
> queries take more than minute to execute. This happens only occasionally
> on a very specific query that joins couple of big tables.
> Now the queries are fairly complex and unoptimized but that is not what
> bothers me. (also changing queries didn't help, may be something to do
> with amounts of data involved?)
> If I run the same query as SA it runs in a second. If I run it as a normal
> user that has been given select permissions on the relevant tables it
> takes ages. Are there any settings for normal users regarding limits on
> resource or something like that?
> We only support two users SA and TheUser as authentication is done server
> side and everything is done through stored procedures spare the read
> queries. TheUser is granted permissions to read some tables and to execute
> the stored procedures nothing else.
> Using the SQL Trace thing... I can see that the offending query does
> approx 350000 reads and 20 writes. I don't know what that means but
> thought it might help you help me ;)
> Thank you,
> Yordan
>
>|||Yordan...
How often do you reindex your database tables?
Yosh
"Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
> Hi,
> We have a working application that has been ok for some time but recently
> as our data and users increased we started to get timeouts as some
> queries take more than minute to execute. This happens only occasionally
> on a very specific query that joins couple of big tables.
> Now the queries are fairly complex and unoptimized but that is not what
> bothers me. (also changing queries didn't help, may be something to do
> with amounts of data involved?)
> If I run the same query as SA it runs in a second. If I run it as a normal
> user that has been given select permissions on the relevant tables it
> takes ages. Are there any settings for normal users regarding limits on
> resource or something like that?
> We only support two users SA and TheUser as authentication is done server
> side and everything is done through stored procedures spare the read
> queries. TheUser is granted permissions to read some tables and to execute
> the stored procedures nothing else.
> Using the SQL Trace thing... I can see that the offending query does
> approx 350000 reads and 20 writes. I don't know what that means but
> thought it might help you help me ;)
> Thank you,
> Yordan
>
>|||Tables are not indexed... (yeah, I know)
I'll probably index to improve but I don't understand the difference the
actual user makes.Why would it work with SA? Is there any quota on resources
spared on one user? Session? I'd like to understand that...
Also same query runs fine most of the time but occasionally is taking >
minute.
its something of the sort (the actual query is too long):
select some stuff from table1 outer left join (select * from table 2) ON
(conditions) where other conditions
table1 is approx 40,000 rows
table2 is approx 600,000 rows
-Yordan
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OQ1SjFdzFHA.2652@.TK2MSFTNGP14.phx.gbl...
> It is impossible to say without actually seeing the query and the DDL for
> the tables involved but it sounds liek it is not using an index and
> scanning the table at least once, probably more. Can you post the other
> info?
> --
> Andrew J. Kelly SQL MVP
>
> "Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
> news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
>|||Thanks for the links. I'll try this tomorrow as I'm home now.
To be honest it does feel like a block because I've seen few before. Its
just I don't see how it can be this time.
Thanks,
Yordan
"JT" <someone@.microsoft.com> wrote in message
news:e%23daTHdzFHA.692@.TK2MSFTNGP10.phx.gbl...
> If timeouts occur "only occasionally", then perhaps your problem is with
> blocking:
> INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
> http://support.microsoft.com/defaul...kb;EN-US;224453
> Use SQL Server Profiler to verify that your SP is making good use of
> indexes. Also, as your table gets larger, fragmentation may become an
> issue that needs periodic maintenance.
> How To: Use SQL Profiler
> http://msdn.microsoft.com/library/d...enethowto15.asp
> Planning and Creating Indexes
> http://www.microsoft.com/technet/pr...s/c0618260.mspx
> Microsoft SQL Server 2000 Index Defragmentation Best Practices
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx[/ur
l]
>
> "Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
> news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
>|||I make my app dump the query in text. (so T-SQL code is the same).
Then I use the Query Analyzer to log-in and execute it. Using TheUser
outcomes are identical. With SA I've tried only the Analyser.
The difference in time is obvious. The exact times I get from the server
manager - using Trace (not sure about the name).
Thanks,
Yordan
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OnLPIGdzFHA.3256@.TK2MSFTNGP09.phx.gbl...
> Yordan,
> Are you logging into Query Analyzer using SA and TheUser to make the
> comparisons in time? Same T-SQL code? Are there any differences in the
> execution plans chosen?
> HTH
> Jerry
> "Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
> news:%234EzR%23czFHA.2312@.TK2MSFTNGP14.phx.gbl...
>|||Here is an easy way to tell if it is a blocking problem. The next time a
query seems to be hung up, then run sp_who2. If a process has another
processes's SPID listed in the [blkby] column, then it is being blocked.
"Yordan Gyurchev" <yg@.gyurchev.com> wrote in message
news:%23u6dfXdzFHA.2348@.TK2MSFTNGP15.phx.gbl...
> Thanks for the links. I'll try this tomorrow as I'm home now.
> To be honest it does feel like a block because I've seen few before. Its
> just I don't see how it can be this time.
> Thanks,
> Yordan
> "JT" <someone@.microsoft.com> wrote in message
> news:e%23daTHdzFHA.692@.TK2MSFTNGP10.phx.gbl...
>|||Is it possible that since you run the same exact query as SA the execution
plan is already cached from the app and SQL server returns the result much
faster a second time
if the app user runs the same query twice does it take a long time both time
s?
http://sqlservercode.blogspot.com/
"Yordan Gyurchev" wrote:

> I make my app dump the query in text. (so T-SQL code is the same).
> Then I use the Query Analyzer to log-in and execute it. Using TheUser
> outcomes are identical. With SA I've tried only the Analyser.
> The difference in time is obvious. The exact times I get from the server
> manager - using Trace (not sure about the name).
> Thanks,
> Yordan
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OnLPIGdzFHA.3256@.TK2MSFTNGP09.phx.gbl...
>
>

Bad alignment issue in Firefox browser

Hi ,

Report when displayed in firefox browser the alignment is disturbed alot.

But when same report is viewed in IE browser its working fine.

Thanx in advance.

Thanks & Regards,

KK

Actually firefox browser won't support SSRS 100% as IE. We need to design the report in such a way for Firefox.

One thing you can try to put all the textbox objects inside a rectangle.

Senthil.

backups working but backup files are not being removed

Hello:
We have a SQL Server 2000 client who has a maintenance plan that does a full
backup of course of its databases. And, each database is using the Full
recovery model.
The backup of the databases itself is working perfectly. But, the backup
files (mdf files) are not being removed. You see, the maintenance plan
specifies that backup files are to be removed every 2 days. That's not
happening?
Why would that be? I mean, why would part of the maintenance plan (the
backing up of the databases) work but another part of the plan (the removal
of the database files) not work?
Thanks!
childofthe1980s
MDF files are actually the real data files. Maintenance plans will remove
only .BAK files pertaining to FULL database or Transaction log.
Thanks
Hari
"childofthe1980s" wrote:

> Hello:
> We have a SQL Server 2000 client who has a maintenance plan that does a full
> backup of course of its databases. And, each database is using the Full
> recovery model.
> The backup of the databases itself is working perfectly. But, the backup
> files (mdf files) are not being removed. You see, the maintenance plan
> specifies that backup files are to be removed every 2 days. That's not
> happening?
> Why would that be? I mean, why would part of the maintenance plan (the
> backing up of the databases) work but another part of the plan (the removal
> of the database files) not work?
> Thanks!
> childofthe1980s
|||Actually, that's what I meant. Sorry for the confusion.
Yes, it is "bak" files I'm concerned about.
Here's an update. I spoke with the client and had him add a group that
contains that SQL Server Agent startup account to have Full Control of the
MSSQL folder so that the root backup folder wold contain Full Control for
this group.
Now, the startup account already had Full Control anyway. But, if the group
that the startup account had "Access is Denied", then the startup account
would be denied permissions. I don't know how to tell if the group was being
denied access. But, that's what I have done so far to eliminate this issue.
Is there anything else?
childofthe1980s
"Hari Prasad" wrote:
[vbcol=seagreen]
> MDF files are actually the real data files. Maintenance plans will remove
> only .BAK files pertaining to FULL database or Transaction log.
> Thanks
> Hari
> "childofthe1980s" wrote:

backups working but backup files are not being removed

Hello:
We have a SQL Server 2000 client who has a maintenance plan that does a full
backup of course of its databases. And, each database is using the Full
recovery model.
The backup of the databases itself is working perfectly. But, the backup
files (mdf files) are not being removed. You see, the maintenance plan
specifies that backup files are to be removed every 2 days. That's not
happening?
Why would that be? I mean, why would part of the maintenance plan (the
backing up of the databases) work but another part of the plan (the removal
of the database files) not work?
Thanks!
childofthe1980sMDF files are actually the real data files. Maintenance plans will remove
only .BAK files pertaining to FULL database or Transaction log.
Thanks
Hari
"childofthe1980s" wrote:

> Hello:
> We have a SQL Server 2000 client who has a maintenance plan that does a fu
ll
> backup of course of its databases. And, each database is using the Full
> recovery model.
> The backup of the databases itself is working perfectly. But, the backup
> files (mdf files) are not being removed. You see, the maintenance plan
> specifies that backup files are to be removed every 2 days. That's not
> happening?
> Why would that be? I mean, why would part of the maintenance plan (the
> backing up of the databases) work but another part of the plan (the remova
l
> of the database files) not work?
> Thanks!
> childofthe1980s|||Actually, that's what I meant. Sorry for the confusion.
Yes, it is "bak" files I'm concerned about.
Here's an update. I spoke with the client and had him add a group that
contains that SQL Server Agent startup account to have Full Control of the
MSSQL folder so that the root backup folder wold contain Full Control for
this group.
Now, the startup account already had Full Control anyway. But, if the group
that the startup account had "Access is Denied", then the startup account
would be denied permissions. I don't know how to tell if the group was bein
g
denied access. But, that's what I have done so far to eliminate this issue.
Is there anything else?
childofthe1980s
"Hari Prasad" wrote:
[vbcol=seagreen]
> MDF files are actually the real data files. Maintenance plans will remove
> only .BAK files pertaining to FULL database or Transaction log.
> Thanks
> Hari
> "childofthe1980s" wrote:
>

Backups using SQL Server

Is it possible to backup a remote SQL Server database to my local system? It is not working for me as I'm getting error as given below

Cannot open backup device 'path'. Device error or device offline

Any idea??

No. MSSQL only backs up locally. You could have it save to an ftp directory and download it that way.

Have a good day.|||

I tried but it didn't worked. Can you post the steps here?

|||I you are using the SQL Manager use should be able to right click on the database that you wish to back up and hover over all tasks. Then select backup, This will bring up the screen for backups. On that screen click the select device button and set the device to the directory that you want to backup to. Then name the file whatever.bak. Start the backup and you are done. Open up the folder and the file will be where you selected it to save to. If that folder is available via FTP then you can download it.

I hope that this helps.

Backups of tran log not working

I have my maintenance plan set up to backup to disk each day, including the
tran log.
I am getting an error on the Tran log backup, however.
It doesn't tell me why it failed, just that it failed.
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The Job
was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1 (Step
1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The help center is no help.
The other 3 parts of the maintenance plan seem to go fine.
Also, there is no log in the Sql Logs, but there is in the Event log (where
I got this). There is plenty of disk space, so that is not the problem.
Am I missing something here?
Thanks,
Tom
Specify a report file for the maint plan and check that for specific error messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:ubIr1UV5FHA.3876@.TK2MSFTNGP09.phx.gbl...
>I have my maintenance plan set up to backup to disk each day, including the tran log.
> I am getting an error on the Tran log backup, however.
> It doesn't tell me why it failed, just that it failed.
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance
> Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status: Failed - Invoked on: 2005-11-09 09:24:24 -
> Message: The job failed. The Job was invoked by User FTSOLUTIONS0\tfs. The last step to run was
> step 1 (Step 1).
> For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
> The help center is no help.
> The other 3 parts of the maintenance plan seem to go fine.
> Also, there is no log in the Sql Logs, but there is in the Event log (where I got this). There is
> plenty of disk space, so that is not the problem.
> Am I missing something here?
> Thanks,
> Tom
>
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edxoSaV5FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Specify a report file for the maint plan and check that for specific error
> messages.
I did that and got to following:
************************************************** ************************************************** *
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'VENUS' as 'FTSOLUTIONS0\servicesql' (trusted)
Starting maintenance plan 'All Databases Backup' on 11/9/2005 10:33:23 AM
Backup can not be performed on database 'FTS'. This sub task is ignored.
Backup can not be performed on database 'master'. This sub task is ignored.
[3] Database model: Transaction Log Backup...
Destination: [d:\Microsoft SQL
Server\MSSQL\BACKUP\model_tlog_200511091033.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[4] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
End of maintenance plan 'All Databases Backup' on 11/9/2005 10:33:24 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
************************************************** ************************************************** *
So it works for some and not others.
And why can't it backup master or msdb - they have log files
Also, there are files that are unreadable there: ERRORLOG, ERRORLOG.1,
SQLAGENT.OUT, SQLAGENT.1. What are they and how do you read them?
Thanks,
Tom
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:ubIr1UV5FHA.3876@.TK2MSFTNGP09.phx.gbl...
>
|||I think that master & msdb are simple recovery model, hence cannot have
tran. log backups. Just remove this portion of your maintenence plan.
|||Ok.
But why did FTS not backup?
Tom
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131562250.817157.160290@.g43g2000cwa.googlegr oups.com...
>I think that master & msdb are simple recovery model, hence cannot have
> tran. log backups. Just remove this portion of your maintenence plan.
>
|||Most log backups fail because the database is in simple recovery mode. Check
that first. Second, verify the database has had a full backup. Finally, I
assume we're not talking about the msdb and master--but just to be safe,
it's not one of those two, correct?
"tshad" wrote:

> I have my maintenance plan set up to backup to disk each day, including the
> tran log.
> I am getting an error on the Tran log backup, however.
> It doesn't tell me why it failed, just that it failed.
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
> Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The Job
> was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1 (Step
> 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> The help center is no help.
> The other 3 parts of the maintenance plan seem to go fine.
> Also, there is no log in the Sql Logs, but there is in the Event log (where
> I got this). There is plenty of disk space, so that is not the problem.
> Am I missing something here?
> Thanks,
> Tom
>
>
|||>From his report, it looks like we are talking about master & msdb. As
well as one other called FTS. Like fnguy said - check to see if if FTS
is simple recovery model. If it is, you can't back up the tran. log.
Backup can not be performed on database 'FTS'. This sub task is
ignored.
Backup can not be performed on database 'master'. This sub task is
ignored.
Backup can not be performed on database 'msdb'. This sub task is
ignored.
|||"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:90AC17EA-75F3-45C0-BA2D-C5CB3600AF4C@.microsoft.com...
> Most log backups fail because the database is in simple recovery mode.
> Check
> that first. Second, verify the database has had a full backup. Finally,
> I
> assume we're not talking about the msdb and master--but just to be safe,
> it's not one of those two, correct?
No, it isn't. It's one of our normal databases.
But you mentioned, the database having a full backup.
Do you need to do the Tran backup first?
Thanks,
Tom[vbcol=seagreen]
>
> "tshad" wrote:
|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131567831.621737.163390@.g43g2000cwa.googlegr oups.com...
> well as one other called FTS. Like fnguy said - check to see if if FTS
> is simple recovery model. If it is, you can't back up the tran. log.
> Backup can not be performed on database 'FTS'. This sub task is
> ignored.
> Backup can not be performed on database 'master'. This sub task is
> ignored.
> Backup can not be performed on database 'msdb'. This sub task is
> ignored.
>
How do you check to see if it is a simple recovery model? I assume it
isn't, but I am not sure.
Tom
|||Check the recovery model of your database.
If the FTS database is in Simple recovery model, then log backups make no
sense.

> Also, there are files that are unreadable there: ERRORLOG, ERRORLOG.1,
> SQLAGENT.OUT, SQLAGENT.1. What are they and how do you read them?
>
ERRORLOG.n are the SQL error logs. They are simple text files. You should
be able to open them in notepad unless there is some strange protection
applied. As an administrator you should certainly be agle to read them.
Kevin Farlee

Backups of tran log not working

I have my maintenance plan set up to backup to disk each day, including the
tran log.
I am getting an error on the Tran log backup, however.
It doesn't tell me why it failed, just that it failed.
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The Job
was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1 (Step
1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The help center is no help.
The other 3 parts of the maintenance plan seem to go fine.
Also, there is no log in the Sql Logs, but there is in the Event log (where
I got this). There is plenty of disk space, so that is not the problem.
Am I missing something here?
Thanks,
TomSpecify a report file for the maint plan and check that for specific error m
essages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:ubIr1UV5FHA.3876@.TK2MSFTNGP09.phx.gbl...
>I have my maintenance plan set up to backup to disk each day, including the
tran log.
> I am getting an error on the Tran log backup, however.
> It doesn't tell me why it failed, just that it failed.
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Pl
an 'DB Maintenance
> Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status: Failed - Invoked on
: 2005-11-09 09:24:24 -
> Message: The job failed. The Job was invoked by User FTSOLUTIONS0\tfs. T
he last step to run was
> step 1 (Step 1).
> For more information, see Help and Support Center at http://go.microsoft.com/fwl
ink/events.asp.
> The help center is no help.
> The other 3 parts of the maintenance plan seem to go fine.
> Also, there is no log in the Sql Logs, but there is in the Event log (wher
e I got this). There is
> plenty of disk space, so that is not the problem.
> Am I missing something here?
> Thanks,
> Tom
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edxoSaV5FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Specify a report file for the maint plan and check that for specific error
> messages.
I did that and got to following:
****************************************
************************************
*************************
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'VENUS' as 'FTSOLUTIONS0\servicesql' (trusted)
Starting maintenance plan 'All Databases Backup' on 11/9/2005 10:33:23 AM
Backup can not be performed on database 'FTS'. This sub task is ignored.
Backup can not be performed on database 'master'. This sub task is ignored.
[3] Database model: Transaction Log Backup...
Destination: [d:\Microsoft SQL
Server\MSSQL\BACKUP\model_tlog_200511091
033.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[4] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
End of maintenance plan 'All Databases Backup' on 11/9/2005 10:33:24 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
****************************************
************************************
*************************
So it works for some and not others.
And why can't it backup master or msdb - they have log files
Also, there are files that are unreadable there: ERRORLOG, ERRORLOG.1,
SQLAGENT.OUT, SQLAGENT.1. What are they and how do you read them?
Thanks,
Tom
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:ubIr1UV5FHA.3876@.TK2MSFTNGP09.phx.gbl...
>|||I think that master & msdb are simple recovery model, hence cannot have
tran. log backups. Just remove this portion of your maintenence plan.|||Ok.
But why did FTS not backup?
Tom
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131562250.817157.160290@.g43g2000cwa.googlegroups.com...
>I think that master & msdb are simple recovery model, hence cannot have
> tran. log backups. Just remove this portion of your maintenence plan.
>|||Most log backups fail because the database is in simple recovery mode. Chec
k
that first. Second, verify the database has had a full backup. Finally, I
assume we're not talking about the msdb and master--but just to be safe,
it's not one of those two, correct?
"tshad" wrote:

> I have my maintenance plan set up to backup to disk each day, including th
e
> tran log.
> I am getting an error on the Tran log backup, however.
> It doesn't tell me why it failed, just that it failed.
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Pl
an
> 'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
> Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The J
ob
> was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1 (St
ep
> 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> The help center is no help.
> The other 3 parts of the maintenance plan seem to go fine.
> Also, there is no log in the Sql Logs, but there is in the Event log (wher
e
> I got this). There is plenty of disk space, so that is not the problem.
> Am I missing something here?
> Thanks,
> Tom
>
>|||>From his report, it looks like we are talking about master & msdb. As
well as one other called FTS. Like fnguy said - check to see if if FTS
is simple recovery model. If it is, you can't back up the tran. log.
Backup can not be performed on database 'FTS'. This sub task is
ignored.
Backup can not be performed on database 'master'. This sub task is
ignored.
Backup can not be performed on database 'msdb'. This sub task is
ignored.|||"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:90AC17EA-75F3-45C0-BA2D-C5CB3600AF4C@.microsoft.com...
> Most log backups fail because the database is in simple recovery mode.
> Check
> that first. Second, verify the database has had a full backup. Finally,
> I
> assume we're not talking about the msdb and master--but just to be safe,
> it's not one of those two, correct?
No, it isn't. It's one of our normal databases.
But you mentioned, the database having a full backup.
Do you need to do the Tran backup first?
Thanks,
Tom[vbcol=seagreen]
>
> "tshad" wrote:
>|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
> well as one other called FTS. Like fnguy said - check to see if if FTS
> is simple recovery model. If it is, you can't back up the tran. log.
> Backup can not be performed on database 'FTS'. This sub task is
> ignored.
> Backup can not be performed on database 'master'. This sub task is
> ignored.
> Backup can not be performed on database 'msdb'. This sub task is
> ignored.
>
How do you check to see if it is a simple recovery model? I assume it
isn't, but I am not sure.
Tom|||Check the recovery model of your database.
If the FTS database is in Simple recovery model, then log backups make no
sense.

> Also, there are files that are unreadable there: ERRORLOG, ERRORLOG.1,
> SQLAGENT.OUT, SQLAGENT.1. What are they and how do you read them?
>
ERRORLOG.n are the SQL error logs. They are simple text files. You should
be able to open them in notepad unless there is some strange protection
applied. As an administrator you should certainly be agle to read them.
Kevin Farlee

Backups of tran log not working

I have my maintenance plan set up to backup to disk each day, including the
tran log.
I am getting an error on the Tran log backup, however.
It doesn't tell me why it failed, just that it failed.
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The Job
was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1 (Step
1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The help center is no help.
The other 3 parts of the maintenance plan seem to go fine.
Also, there is no log in the Sql Logs, but there is in the Event log (where
I got this). There is plenty of disk space, so that is not the problem.
Am I missing something here?
Thanks,
TomSpecify a report file for the maint plan and check that for specific error messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:ubIr1UV5FHA.3876@.TK2MSFTNGP09.phx.gbl...
>I have my maintenance plan set up to backup to disk each day, including the tran log.
> I am getting an error on the Tran log backup, however.
> It doesn't tell me why it failed, just that it failed.
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance
> Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status: Failed - Invoked on: 2005-11-09 09:24:24 -
> Message: The job failed. The Job was invoked by User FTSOLUTIONS0\tfs. The last step to run was
> step 1 (Step 1).
> For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
> The help center is no help.
> The other 3 parts of the maintenance plan seem to go fine.
> Also, there is no log in the Sql Logs, but there is in the Event log (where I got this). There is
> plenty of disk space, so that is not the problem.
> Am I missing something here?
> Thanks,
> Tom
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edxoSaV5FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Specify a report file for the maint plan and check that for specific error
> messages.
I did that and got to following:
*****************************************************************************************************
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'VENUS' as 'FTSOLUTIONS0\servicesql' (trusted)
Starting maintenance plan 'All Databases Backup' on 11/9/2005 10:33:23 AM
Backup can not be performed on database 'FTS'. This sub task is ignored.
Backup can not be performed on database 'master'. This sub task is ignored.
[3] Database model: Transaction Log Backup...
Destination: [d:\Microsoft SQL
Server\MSSQL\BACKUP\model_tlog_200511091033.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[4] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
End of maintenance plan 'All Databases Backup' on 11/9/2005 10:33:24 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
*****************************************************************************************************
So it works for some and not others.
And why can't it backup master or msdb - they have log files
Also, there are files that are unreadable there: ERRORLOG, ERRORLOG.1,
SQLAGENT.OUT, SQLAGENT.1. What are they and how do you read them?
Thanks,
Tom
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:ubIr1UV5FHA.3876@.TK2MSFTNGP09.phx.gbl...
>>I have my maintenance plan set up to backup to disk each day, including
>>the tran log.
>> I am getting an error on the Tran log backup, however.
>> It doesn't tell me why it failed, just that it failed.
>> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
>> Plan 'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) -
>> Status: Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job
>> failed. The Job was invoked by User FTSOLUTIONS0\tfs. The last step to
>> run was step 1 (Step 1).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>> The help center is no help.
>> The other 3 parts of the maintenance plan seem to go fine.
>> Also, there is no log in the Sql Logs, but there is in the Event log
>> (where I got this). There is plenty of disk space, so that is not the
>> problem.
>> Am I missing something here?
>> Thanks,
>> Tom
>|||I think that master & msdb are simple recovery model, hence cannot have
tran. log backups. Just remove this portion of your maintenence plan.|||Ok.
But why did FTS not backup?
Tom
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131562250.817157.160290@.g43g2000cwa.googlegroups.com...
>I think that master & msdb are simple recovery model, hence cannot have
> tran. log backups. Just remove this portion of your maintenence plan.
>|||Most log backups fail because the database is in simple recovery mode. Check
that first. Second, verify the database has had a full backup. Finally, I
assume we're not talking about the msdb and master--but just to be safe,
it's not one of those two, correct?
"tshad" wrote:
> I have my maintenance plan set up to backup to disk each day, including the
> tran log.
> I am getting an error on the Tran log backup, however.
> It doesn't tell me why it failed, just that it failed.
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
> Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The Job
> was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1 (Step
> 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> The help center is no help.
> The other 3 parts of the maintenance plan seem to go fine.
> Also, there is no log in the Sql Logs, but there is in the Event log (where
> I got this). There is plenty of disk space, so that is not the problem.
> Am I missing something here?
> Thanks,
> Tom
>
>|||>From his report, it looks like we are talking about master & msdb. As
well as one other called FTS. Like fnguy said - check to see if if FTS
is simple recovery model. If it is, you can't back up the tran. log.
Backup can not be performed on database 'FTS'. This sub task is
ignored.
Backup can not be performed on database 'master'. This sub task is
ignored.
Backup can not be performed on database 'msdb'. This sub task is
ignored.|||"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:90AC17EA-75F3-45C0-BA2D-C5CB3600AF4C@.microsoft.com...
> Most log backups fail because the database is in simple recovery mode.
> Check
> that first. Second, verify the database has had a full backup. Finally,
> I
> assume we're not talking about the msdb and master--but just to be safe,
> it's not one of those two, correct?
No, it isn't. It's one of our normal databases.
But you mentioned, the database having a full backup.
Do you need to do the Tran backup first?
Thanks,
Tom
>
> "tshad" wrote:
>> I have my maintenance plan set up to backup to disk each day, including
>> the
>> tran log.
>> I am getting an error on the Tran log backup, however.
>> It doesn't tell me why it failed, just that it failed.
>> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
>> Plan
>> 'DB Maintenance Plan1'' (0x6B83341EBF11A04CB613509A341733CB) - Status:
>> Failed - Invoked on: 2005-11-09 09:24:24 - Message: The job failed. The
>> Job
>> was invoked by User FTSOLUTIONS0\tfs. The last step to run was step 1
>> (Step
>> 1).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>> The help center is no help.
>> The other 3 parts of the maintenance plan seem to go fine.
>> Also, there is no log in the Sql Logs, but there is in the Event log
>> (where
>> I got this). There is plenty of disk space, so that is not the problem.
>> Am I missing something here?
>> Thanks,
>> Tom
>>|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
> >From his report, it looks like we are talking about master & msdb. As
> well as one other called FTS. Like fnguy said - check to see if if FTS
> is simple recovery model. If it is, you can't back up the tran. log.
> Backup can not be performed on database 'FTS'. This sub task is
> ignored.
> Backup can not be performed on database 'master'. This sub task is
> ignored.
> Backup can not be performed on database 'msdb'. This sub task is
> ignored.
>
How do you check to see if it is a simple recovery model? I assume it
isn't, but I am not sure.
Tom|||Check the recovery model of your database.
If the FTS database is in Simple recovery model, then log backups make no
sense.
> Also, there are files that are unreadable there: ERRORLOG, ERRORLOG.1,
> SQLAGENT.OUT, SQLAGENT.1. What are they and how do you read them?
>
ERRORLOG.n are the SQL error logs. They are simple text files. You should
be able to open them in notepad unless there is some strange protection
applied. As an administrator you should certainly be agle to read them.
Kevin Farlee|||As Kevin suggested, it is probably in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:%23LFHRAW5FHA.2676@.TK2MSFTNGP15.phx.gbl...
> Ok.
> But why did FTS not backup?
> Tom
> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> news:1131562250.817157.160290@.g43g2000cwa.googlegroups.com...
>>I think that master & msdb are simple recovery model, hence cannot have
>> tran. log backups. Just remove this portion of your maintenence plan.
>|||> How do you check to see if it is a simple recovery model? I assume it isn't, but I am not sure.
sp_helpdb, for instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e%23Y3D3X5FHA.1536@.TK2MSFTNGP12.phx.gbl...
> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
>> >From his report, it looks like we are talking about master & msdb. As
>> well as one other called FTS. Like fnguy said - check to see if if FTS
>> is simple recovery model. If it is, you can't back up the tran. log.
>> Backup can not be performed on database 'FTS'. This sub task is
>> ignored.
>> Backup can not be performed on database 'master'. This sub task is
>> ignored.
>> Backup can not be performed on database 'msdb'. This sub task is
>> ignored.
> How do you check to see if it is a simple recovery model? I assume it isn't, but I am not sure.
> Tom
>|||Pls execute following SP from Query Analyser and post it's output:
sp_helpdb 'fts'
"tshad" wrote:
> "fnguy" <fnguy@.discussions.microsoft.com> wrote in message
> news:90AC17EA-75F3-45C0-BA2D-C5CB3600AF4C@.microsoft.com...
> > Most log backups fail because the database is in simple recovery mode.
> > Check
> > that first. Second, verify the database has had a full backup. Finally,
> > I
> > assume we're not talking about the msdb and master--but just to be safe,
> > it's not one of those two, correct?
> No, it isn't. It's one of our normal databases.
> But you mentioned, the database having a full backup.
> Do you need to do the Tran backup first?
> Thanks,
> Tom|||How do you check to see if it is a simple recovery model? I assume it
isn't, but I am not sure.
--
Also - open enterprise manager, right click the database in question,
and choose properties. Go to options tab. See what exists under the
Recovery model section. If it's simple, then all you can do is full
backups. If it's full, then you can do logs.
Tibor Karaszi wrote:
> > How do you check to see if it is a simple recovery model? I assume it isn't, but I am not sure.
> sp_helpdb, for instance.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e%23Y3D3X5FHA.1536@.TK2MSFTNGP12.phx.gbl...
> >
> > "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> > news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
> >> >From his report, it looks like we are talking about master & msdb. As
> >> well as one other called FTS. Like fnguy said - check to see if if FTS
> >> is simple recovery model. If it is, you can't back up the tran. log.
> >>
> >> Backup can not be performed on database 'FTS'. This sub task is
> >> ignored.
> >> Backup can not be performed on database 'master'. This sub task is
> >> ignored.
> >> Backup can not be performed on database 'msdb'. This sub task is
> >> ignored.
> >>
> >
> > How do you check to see if it is a simple recovery model? I assume it isn't, but I am not sure.
> >
> > Tom
> >|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ejxz3mc5FHA.2364@.TK2MSFTNGP12.phx.gbl...
>> How do you check to see if it is a simple recovery model? I assume it
>> isn't, but I am not sure.
> sp_helpdb, for instance.
That does show it as
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e%23Y3D3X5FHA.1536@.TK2MSFTNGP12.phx.gbl...
>> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
>> news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
>> >From his report, it looks like we are talking about master & msdb. As
>> well as one other called FTS. Like fnguy said - check to see if if FTS
>> is simple recovery model. If it is, you can't back up the tran. log.
>> Backup can not be performed on database 'FTS'. This sub task is
>> ignored.
>> Backup can not be performed on database 'master'. This sub task is
>> ignored.
>> Backup can not be performed on database 'msdb'. This sub task is
>> ignored.
>>
>> How do you check to see if it is a simple recovery model? I assume it
>> isn't, but I am not sure.
>> Tom
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ejxz3mc5FHA.2364@.TK2MSFTNGP12.phx.gbl...
>> How do you check to see if it is a simple recovery model? I assume it
>> isn't, but I am not sure.
> sp_helpdb, for instance.
That was it.
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER,
Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS,
SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics,
IsAutoUpdateStatistics, IsFullTextEnabled
But how did it get that way? What did I do to make it that way? My other
databases aren't that way.
Can I change that?
Thanks,
Tom
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e%23Y3D3X5FHA.1536@.TK2MSFTNGP12.phx.gbl...
>> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
>> news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
>> >From his report, it looks like we are talking about master & msdb. As
>> well as one other called FTS. Like fnguy said - check to see if if FTS
>> is simple recovery model. If it is, you can't back up the tran. log.
>> Backup can not be performed on database 'FTS'. This sub task is
>> ignored.
>> Backup can not be performed on database 'master'. This sub task is
>> ignored.
>> Backup can not be performed on database 'msdb'. This sub task is
>> ignored.
>>
>> How do you check to see if it is a simple recovery model? I assume it
>> isn't, but I am not sure.
>> Tom
>|||Yes, you can change it using the ALTER DATABASE command.
How it got set to simple in the first place? I can't answer that, except saying that someone or some
program did it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"tshad" <tscheiderich@.ftsolutions.com> wrote in message news:uP89yUh5FHA.140@.TK2MSFTNGP10.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ejxz3mc5FHA.2364@.TK2MSFTNGP12.phx.gbl...
>> How do you check to see if it is a simple recovery model? I assume it isn't, but I am not sure.
>> sp_helpdb, for instance.
> That was it.
> Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539,
> Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled,
> IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled
> But how did it get that way? What did I do to make it that way? My other databases aren't that
> way.
> Can I change that?
> Thanks,
> Tom
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
>> news:e%23Y3D3X5FHA.1536@.TK2MSFTNGP12.phx.gbl...
>> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
>> news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
>> >From his report, it looks like we are talking about master & msdb. As
>> well as one other called FTS. Like fnguy said - check to see if if FTS
>> is simple recovery model. If it is, you can't back up the tran. log.
>> Backup can not be performed on database 'FTS'. This sub task is
>> ignored.
>> Backup can not be performed on database 'master'. This sub task is
>> ignored.
>> Backup can not be performed on database 'msdb'. This sub task is
>> ignored.
>>
>> How do you check to see if it is a simple recovery model? I assume it isn't, but I am not sure.
>> Tom
>>
>|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1131630158.667899.30870@.g44g2000cwa.googlegroups.com...
> How do you check to see if it is a simple recovery model? I assume it
> isn't, but I am not sure.
> --
> Also - open enterprise manager, right click the database in question,
> and choose properties. Go to options tab. See what exists under the
> Recovery model section. If it's simple, then all you can do is full
> backups. If it's full, then you can do logs.
>
Can I just change that there?
Why would you want a simple model?
It does have a tran log defined for it and it is the only one of 5 databases
I have that isn't full. So what causes it to be simple I just created
another database, it has no question about it and it automatically made it
simple. I originally created FTS in this way - so what would cause it to be
simple - I know I didn't do it manually.
Thanks,
Tom
>
> Tibor Karaszi wrote:
>> > How do you check to see if it is a simple recovery model? I assume it
>> > isn't, but I am not sure.
>> sp_helpdb, for instance.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
>> news:e%23Y3D3X5FHA.1536@.TK2MSFTNGP12.phx.gbl...
>> >
>> > "Corey Bunch" <unc27932@.yahoo.com> wrote in message
>> > news:1131567831.621737.163390@.g43g2000cwa.googlegroups.com...
>> >> >From his report, it looks like we are talking about master & msdb.
>> >> >As
>> >> well as one other called FTS. Like fnguy said - check to see if if
>> >> FTS
>> >> is simple recovery model. If it is, you can't back up the tran. log.
>> >>
>> >> Backup can not be performed on database 'FTS'. This sub task is
>> >> ignored.
>> >> Backup can not be performed on database 'master'. This sub task is
>> >> ignored.
>> >> Backup can not be performed on database 'msdb'. This sub task is
>> >> ignored.
>> >>
>> >
>> > How do you check to see if it is a simple recovery model? I assume it
>> > isn't, but I am not sure.
>> >
>> > Tom
>> >
>|||Yes - you can just change that there using the drop down. Not sure why
it's full instead of simple. Simple model = less maintenance, but also
= less recoverability. See below links.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1069109,00.html
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp
>From microsoft...
Simple Recovery Model
This recovery model facilitates the maintenance of a database by making
the transaction log virtually maintenance free. There are limitations
placed on the recoverability of a database if this recovery model is
used.

Backups from SQLcmd ?

I am working with SQL Express and found myself surprised when I tried to automate a backup... No Agent.

So I am trying to create a simple backup script to run from the command line and probably schedule through the scheduled task manager.

here is my problem. I get the following error :

Msg 2812, Level 16, State 62, Server FIREFLY\SQLEXPRESS, Line 1
Could not find stored procedure 'B'.

Here is the batch file

sqlcmd -i c:\temp\test\DBbackup.sql -o c:\temp\test\output.txt -S FIREFLY\SQLEXPRESS

And here is the sql input file :

BACKUP DATABASE [DNNDEV] TO DISK = 'C:\temp\test\dnndev.bak' WITH NOFORMAT, NOINIT, NAME = 'dnndev-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10;

If I put a USE statement in front of my backup statement - the error message changes to

Could not find stored procedure 'U'.

So it would appear to list the first character encountered.

As a sanity check I created a similar process which does a select * from a table and I do not get an error saying :Could not find stored procedure 'S'. - instead all is well and I get my output and no error

If I try the backup command in SQLCMD interactively it works.

so what the heck am I missing ?

Thank you for any help...

What editor did you use to save the SQL file? Sounds like you generated a unicode file without BOM (byte order mark) so it is treated as ANSI file. Check the save options of your editor. Notepad for example has a combo box in its save dialog where you should choose ANSI. Unicode will save 2 or more byte per character. For standard letters it is often the ANSI code followed by a 0 byte, which is a terminator for ASCII c strings - so I guess sqlcmd stops after hitting the first 0 byte which follows your first letter.

--
SvenC

|||

Yep - That did it. Somehow my other test using the select statement must have been saved in ANSI - my backup file was saved in unicode

Thanks a million !

Backup/Restore SQL DB - webhost4life

I'm working with someone right now who wants to beable to click on a link and instantly beable to restore a SQL database from his hard drive or backup a SQL database to his hard drive.

I talked to webhost4life about this (where my MSSQL databases are hosted) and this is their response:

"The only way you can backup or restore a database yourself is by going to hosting control panel. You can have your clients contact us with the hosting account member ID and the database login information so we can do a manual restore or backup for them. "

This is the only way? This is not sufficient for my client that I am working with.

I've searched the forum for this and have received mixed responses. Some say to research SQLDMO and i've even seen this for restore, which I couldn't get to work:

strSQL = "RESTORE DATABASE [WebReqs] FROM DISK = N'C:\Inetpub\wwwroot\Administration\Database\WebReqsVanilla.bak' WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , REPLACE , MOVE N'WebReqs_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\WebReqs_data.mdf', MOVE N'WebReqs_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\WebReqs_log.ldf'"

I can't seem to get anything to work and webhost4life says it's not possible. Is there any other way??
TIAIs DTS (SQL Server Tools) working with webhost4life?|||I've successfully backed up my webhost4life database using DTS/Enterprise Manager. I don't actually do a backup though, I just pull down all the objects (do an object transfer). This will back up all the tables, sprocs, views and data, which for most web database scenerios is sufficient.

A normal Backup and Restore require sysadmin level permissions, which they are certainly not going to give you on a shared database server. I think there is a way to give that level of permission at the database level, but even if they did you would not be able to tell the remote server where you wanted the backup file (the location). In other words, it would not backup to your local computer where you could get at it.

cs|||The Intro to Webmatrix book has some scripts included for uploading/downloading table schema and data from MSDE/SQL.

They must be here on the site somewhere as well.

In the book, there's a disclaimer about security, you need remove the pages from the host server after you use them.

backup/restore from SQL 2000 to SQL 2005: diagram ownership

I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
and machine name\my login name.
(2) Copy backup file to another machine with SQL Server 2005.
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database.
(5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
work.
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I do not know the detail steps for doing it. In the MSDN, it suggests that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
It is OK for exec.
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
This produces an error: 15151
Are there any tricks in backup and restore process?
Thank you for any help.
David> This produces an error: 15151
Can you show us the error message and not only the error number?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"david" <david@.discussions.microsoft.com> wrote in message
news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> I have trouble with it. I have tried several ways and talked to some peopl
e
> in the forum, but it is not working. The following is waht I did.
> (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> and machine name\my login name.
> (2) Copy backup file to another machine with SQL Server 2005.
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database.
> (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> work.
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this databas
e
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog bo
x
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I do not know the detail steps for doing it. In the MSDN, it suggests that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> It is OK for exec.
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> This produces an error: 15151
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
>|||Can not find the principal 'valid_login', because it does not exist.
Should 'valid_login' be a user name?
How to create a correct user name?
I created one, and use the username instead of 'valid_login' and got same
error.
David
"Tibor Karaszi" wrote:

> Can you show us the error message and not only the error number?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
>|||If "valid_login" is a username, how to create such a user?
any detail steps?
Thanks
David
"Tibor Karaszi" wrote:

> Can you show us the error message and not only the error number?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
>|||> Should 'valid_login' be a user name?
No, it should be a login name. If you don't know the difference between a lo
gin and a user, I
strongly suggest you read up on the subject. Here's a good start:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808
659449c5.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"david" <david@.discussions.microsoft.com> wrote in message
news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...[vbcol=seagreen]
> Can not find the principal 'valid_login', because it does not exist.
> Should 'valid_login' be a user name?
> How to create a correct user name?
> I created one, and use the username instead of 'valid_login' and got same
> error.
> David
> "Tibor Karaszi" wrote:
>|||Is a lohin name displayed under security under databases tree node?
David
"Tibor Karaszi" wrote:

> No, it should be a login name. If you don't know the difference between a
login and a user, I
> strongly suggest you read up on the subject. Here's a good start:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-78
08659449c5.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
>|||No, under the server node (the root node), in the security folder.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"david" <david@.discussions.microsoft.com> wrote in message
news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...[vbcol=seagreen]
> Is a lohin name displayed under security under databases tree node?
> David
> "Tibor Karaszi" wrote:
>|||Thank you.
so my login name in new machine should be (under sqlserver\security\logins:
new_machine_name\Firstname Lastname (a sapce between them)
So I should use
ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
Lastname
Now I get error:
incorrect syntax near 'new_machine_name'.
How to correct it?
David
"Tibor Karaszi" wrote:

> No, under the server node (the root node), in the security folder.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...
>|||I use
ALTER AUTHORIZATION on DATABASE::databasename TO new_machine_name\Firstname
Lastname
and got error: Incorrect syntax near ''.
David
"david" wrote:
[vbcol=seagreen]
> Thank you.
> so my login name in new machine should be (under sqlserver\security\logins
:
> new_machine_name\Firstname Lastname (a sapce between them)
> So I should use
> ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
> Lastname
> Now I get error:
> incorrect syntax near 'new_machine_name'.
> How to correct it?
> David
> "Tibor Karaszi" wrote:
>|||I used
ALTER AUTHORIZATION on DATABASE::databasename TO 'new_machine_name\Firstname
Lastname'
and I get error:
incorrect syntax near 'new_machine_name\Firstname Lastname' .
If I use
ALTER AUTHORIZATION on DATABASE::databasename TO new_machine_name\Firstname
Lastname
I fet error: incorrect syntax near ''
David
"david" wrote:
[vbcol=seagreen]
> Thank you.
> so my login name in new machine should be (under sqlserver\security\logins
:
> new_machine_name\Firstname Lastname (a sapce between them)
> So I should use
> ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
> Lastname
> Now I get error:
> incorrect syntax near 'new_machine_name'.
> How to correct it?
> David
> "Tibor Karaszi" wrote:
>

backup/restore from SQL 2000 to SQL 2005: diagram ownership

I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
and machine name\my login name.
(2) Copy backup file to another machine with SQL Server 2005.
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database.
(5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
work.
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I do not know the detail steps for doing it. In the MSDN, it suggests that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
It is OK for exec.
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
This produces an error: 15151
Are there any tricks in backup and restore process?
Thank you for any help.
David> This produces an error: 15151
Can you show us the error message and not only the error number?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"david" <david@.discussions.microsoft.com> wrote in message
news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> I have trouble with it. I have tried several ways and talked to some people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> and machine name\my login name.
> (2) Copy backup file to another machine with SQL Server 2005.
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database.
> (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> work.
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I do not know the detail steps for doing it. In the MSDN, it suggests that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> It is OK for exec.
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> This produces an error: 15151
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
>|||Can not find the principal 'valid_login', because it does not exist.
Should 'valid_login' be a user name?
How to create a correct user name?
I created one, and use the username instead of 'valid_login' and got same
error.
David
"Tibor Karaszi" wrote:
> > This produces an error: 15151
> Can you show us the error message and not only the error number?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> > I have trouble with it. I have tried several ways and talked to some people
> > in the forum, but it is not working. The following is waht I did.
> >
> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> > and machine name\my login name.
> > (2) Copy backup file to another machine with SQL Server 2005.
> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > (4) Use Restore to restore the backup to a database.
> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> > work.
> > the error massage. I can not either display the diagram or create new
> > diagram on the database. The error message:
> > "Database diagram support objects cannot be installed because this database
> > does not have valid owner.
> > To continue, first use the Files page of the Database Properties dialog box
> > ot the Alter Authorization statement
> > to set the database owner to a valid login, then add the datatbase diagram
> > support objects."
> >
> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> > For compatiable, run
> > exec sp_dbcmptlevel 'database_name', '90';
> > It is OK for exec.
> > For alter authorization, run
> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> >
> > This produces an error: 15151
> >
> > Are there any tricks in backup and restore process?
> >
> > Thank you for any help.
> >
> > David
> >
> >
> >
>|||If "valid_login" is a username, how to create such a user?
any detail steps?
Thanks
David
"Tibor Karaszi" wrote:
> > This produces an error: 15151
> Can you show us the error message and not only the error number?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> > I have trouble with it. I have tried several ways and talked to some people
> > in the forum, but it is not working. The following is waht I did.
> >
> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> > and machine name\my login name.
> > (2) Copy backup file to another machine with SQL Server 2005.
> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > (4) Use Restore to restore the backup to a database.
> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> > work.
> > the error massage. I can not either display the diagram or create new
> > diagram on the database. The error message:
> > "Database diagram support objects cannot be installed because this database
> > does not have valid owner.
> > To continue, first use the Files page of the Database Properties dialog box
> > ot the Alter Authorization statement
> > to set the database owner to a valid login, then add the datatbase diagram
> > support objects."
> >
> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> > For compatiable, run
> > exec sp_dbcmptlevel 'database_name', '90';
> > It is OK for exec.
> > For alter authorization, run
> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> >
> > This produces an error: 15151
> >
> > Are there any tricks in backup and restore process?
> >
> > Thank you for any help.
> >
> > David
> >
> >
> >
>|||> Should 'valid_login' be a user name?
No, it should be a login name. If you don't know the difference between a login and a user, I
strongly suggest you read up on the subject. Here's a good start:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"david" <david@.discussions.microsoft.com> wrote in message
news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
> Can not find the principal 'valid_login', because it does not exist.
> Should 'valid_login' be a user name?
> How to create a correct user name?
> I created one, and use the username instead of 'valid_login' and got same
> error.
> David
> "Tibor Karaszi" wrote:
>> > This produces an error: 15151
>> Can you show us the error message and not only the error number?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "david" <david@.discussions.microsoft.com> wrote in message
>> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
>> > I have trouble with it. I have tried several ways and talked to some people
>> > in the forum, but it is not working. The following is waht I did.
>> >
>> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
>> > and machine name\my login name.
>> > (2) Copy backup file to another machine with SQL Server 2005.
>> > (3) Start SQL Server Management Studio of SQL Server 2005.
>> > (4) Use Restore to restore the backup to a database.
>> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
>> > work.
>> > the error massage. I can not either display the diagram or create new
>> > diagram on the database. The error message:
>> > "Database diagram support objects cannot be installed because this database
>> > does not have valid owner.
>> > To continue, first use the Files page of the Database Properties dialog box
>> > ot the Alter Authorization statement
>> > to set the database owner to a valid login, then add the datatbase diagram
>> > support objects."
>> >
>> > I do not know the detail steps for doing it. In the MSDN, it suggests that
>> > For compatiable, run
>> > exec sp_dbcmptlevel 'database_name', '90';
>> > It is OK for exec.
>> > For alter authorization, run
>> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
>> >
>> > This produces an error: 15151
>> >
>> > Are there any tricks in backup and restore process?
>> >
>> > Thank you for any help.
>> >
>> > David
>> >
>> >
>> >|||Is a lohin name displayed under security under databases tree node?
David
"Tibor Karaszi" wrote:
> > Should 'valid_login' be a user name?
> No, it should be a login name. If you don't know the difference between a login and a user, I
> strongly suggest you read up on the subject. Here's a good start:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
> > Can not find the principal 'valid_login', because it does not exist.
> >
> > Should 'valid_login' be a user name?
> >
> > How to create a correct user name?
> >
> > I created one, and use the username instead of 'valid_login' and got same
> > error.
> >
> > David
> >
> > "Tibor Karaszi" wrote:
> >
> >> > This produces an error: 15151
> >>
> >> Can you show us the error message and not only the error number?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "david" <david@.discussions.microsoft.com> wrote in message
> >> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> >> > I have trouble with it. I have tried several ways and talked to some people
> >> > in the forum, but it is not working. The following is waht I did.
> >> >
> >> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> >> > and machine name\my login name.
> >> > (2) Copy backup file to another machine with SQL Server 2005.
> >> > (3) Start SQL Server Management Studio of SQL Server 2005.
> >> > (4) Use Restore to restore the backup to a database.
> >> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> >> > work.
> >> > the error massage. I can not either display the diagram or create new
> >> > diagram on the database. The error message:
> >> > "Database diagram support objects cannot be installed because this database
> >> > does not have valid owner.
> >> > To continue, first use the Files page of the Database Properties dialog box
> >> > ot the Alter Authorization statement
> >> > to set the database owner to a valid login, then add the datatbase diagram
> >> > support objects."
> >> >
> >> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> >> > For compatiable, run
> >> > exec sp_dbcmptlevel 'database_name', '90';
> >> > It is OK for exec.
> >> > For alter authorization, run
> >> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> >> >
> >> > This produces an error: 15151
> >> >
> >> > Are there any tricks in backup and restore process?
> >> >
> >> > Thank you for any help.
> >> >
> >> > David
> >> >
> >> >
> >> >
> >>
>|||No, under the server node (the root node), in the security folder.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"david" <david@.discussions.microsoft.com> wrote in message
news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...
> Is a lohin name displayed under security under databases tree node?
> David
> "Tibor Karaszi" wrote:
>> > Should 'valid_login' be a user name?
>> No, it should be a login name. If you don't know the difference between a login and a user, I
>> strongly suggest you read up on the subject. Here's a good start:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "david" <david@.discussions.microsoft.com> wrote in message
>> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
>> > Can not find the principal 'valid_login', because it does not exist.
>> >
>> > Should 'valid_login' be a user name?
>> >
>> > How to create a correct user name?
>> >
>> > I created one, and use the username instead of 'valid_login' and got same
>> > error.
>> >
>> > David
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> > This produces an error: 15151
>> >>
>> >> Can you show us the error message and not only the error number?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://sqlblog.com/blogs/tibor_karaszi
>> >>
>> >>
>> >> "david" <david@.discussions.microsoft.com> wrote in message
>> >> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
>> >> > I have trouble with it. I have tried several ways and talked to some people
>> >> > in the forum, but it is not working. The following is waht I did.
>> >> >
>> >> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
>> >> > and machine name\my login name.
>> >> > (2) Copy backup file to another machine with SQL Server 2005.
>> >> > (3) Start SQL Server Management Studio of SQL Server 2005.
>> >> > (4) Use Restore to restore the backup to a database.
>> >> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
>> >> > work.
>> >> > the error massage. I can not either display the diagram or create new
>> >> > diagram on the database. The error message:
>> >> > "Database diagram support objects cannot be installed because this database
>> >> > does not have valid owner.
>> >> > To continue, first use the Files page of the Database Properties dialog box
>> >> > ot the Alter Authorization statement
>> >> > to set the database owner to a valid login, then add the datatbase diagram
>> >> > support objects."
>> >> >
>> >> > I do not know the detail steps for doing it. In the MSDN, it suggests that
>> >> > For compatiable, run
>> >> > exec sp_dbcmptlevel 'database_name', '90';
>> >> > It is OK for exec.
>> >> > For alter authorization, run
>> >> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
>> >> >
>> >> > This produces an error: 15151
>> >> >
>> >> > Are there any tricks in backup and restore process?
>> >> >
>> >> > Thank you for any help.
>> >> >
>> >> > David
>> >> >
>> >> >
>> >> >
>> >>
>>|||Thank you.
so my login name in new machine should be (under sqlserver\security\logins:
new_machine_name\Firstname Lastname (a sapce between them)
So I should use
ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
Lastname
Now I get error:
incorrect syntax near 'new_machine_name'.
How to correct it?
David
"Tibor Karaszi" wrote:
> No, under the server node (the root node), in the security folder.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "david" <david@.discussions.microsoft.com> wrote in message
> news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...
> > Is a lohin name displayed under security under databases tree node?
> >
> > David
> >
> > "Tibor Karaszi" wrote:
> >
> >> > Should 'valid_login' be a user name?
> >>
> >> No, it should be a login name. If you don't know the difference between a login and a user, I
> >> strongly suggest you read up on the subject. Here's a good start:
> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "david" <david@.discussions.microsoft.com> wrote in message
> >> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
> >> > Can not find the principal 'valid_login', because it does not exist.
> >> >
> >> > Should 'valid_login' be a user name?
> >> >
> >> > How to create a correct user name?
> >> >
> >> > I created one, and use the username instead of 'valid_login' and got same
> >> > error.
> >> >
> >> > David
> >> >
> >> > "Tibor Karaszi" wrote:
> >> >
> >> >> > This produces an error: 15151
> >> >>
> >> >> Can you show us the error message and not only the error number?
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://sqlblog.com/blogs/tibor_karaszi
> >> >>
> >> >>
> >> >> "david" <david@.discussions.microsoft.com> wrote in message
> >> >> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> >> >> > I have trouble with it. I have tried several ways and talked to some people
> >> >> > in the forum, but it is not working. The following is waht I did.
> >> >> >
> >> >> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> >> >> > and machine name\my login name.
> >> >> > (2) Copy backup file to another machine with SQL Server 2005.
> >> >> > (3) Start SQL Server Management Studio of SQL Server 2005.
> >> >> > (4) Use Restore to restore the backup to a database.
> >> >> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> >> >> > work.
> >> >> > the error massage. I can not either display the diagram or create new
> >> >> > diagram on the database. The error message:
> >> >> > "Database diagram support objects cannot be installed because this database
> >> >> > does not have valid owner.
> >> >> > To continue, first use the Files page of the Database Properties dialog box
> >> >> > ot the Alter Authorization statement
> >> >> > to set the database owner to a valid login, then add the datatbase diagram
> >> >> > support objects."
> >> >> >
> >> >> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> >> >> > For compatiable, run
> >> >> > exec sp_dbcmptlevel 'database_name', '90';
> >> >> > It is OK for exec.
> >> >> > For alter authorization, run
> >> >> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> >> >> >
> >> >> > This produces an error: 15151
> >> >> >
> >> >> > Are there any tricks in backup and restore process?
> >> >> >
> >> >> > Thank you for any help.
> >> >> >
> >> >> > David
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >>
> >>
>|||I use
ALTER AUTHORIZATION on DATABASE::databasename TO new_machine_name\Firstname
Lastname
and got error: Incorrect syntax near '\'.
David
"david" wrote:
> Thank you.
> so my login name in new machine should be (under sqlserver\security\logins:
> new_machine_name\Firstname Lastname (a sapce between them)
> So I should use
> ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
> Lastname
> Now I get error:
> incorrect syntax near 'new_machine_name'.
> How to correct it?
> David
> "Tibor Karaszi" wrote:
> > No, under the server node (the root node), in the security folder.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://sqlblog.com/blogs/tibor_karaszi
> >
> >
> > "david" <david@.discussions.microsoft.com> wrote in message
> > news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...
> > > Is a lohin name displayed under security under databases tree node?
> > >
> > > David
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > >> > Should 'valid_login' be a user name?
> > >>
> > >> No, it should be a login name. If you don't know the difference between a login and a user, I
> > >> strongly suggest you read up on the subject. Here's a good start:
> > >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
> > >>
> > >> --
> > >> Tibor Karaszi, SQL Server MVP
> > >> http://www.karaszi.com/sqlserver/default.asp
> > >> http://sqlblog.com/blogs/tibor_karaszi
> > >>
> > >>
> > >> "david" <david@.discussions.microsoft.com> wrote in message
> > >> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
> > >> > Can not find the principal 'valid_login', because it does not exist.
> > >> >
> > >> > Should 'valid_login' be a user name?
> > >> >
> > >> > How to create a correct user name?
> > >> >
> > >> > I created one, and use the username instead of 'valid_login' and got same
> > >> > error.
> > >> >
> > >> > David
> > >> >
> > >> > "Tibor Karaszi" wrote:
> > >> >
> > >> >> > This produces an error: 15151
> > >> >>
> > >> >> Can you show us the error message and not only the error number?
> > >> >>
> > >> >> --
> > >> >> Tibor Karaszi, SQL Server MVP
> > >> >> http://www.karaszi.com/sqlserver/default.asp
> > >> >> http://sqlblog.com/blogs/tibor_karaszi
> > >> >>
> > >> >>
> > >> >> "david" <david@.discussions.microsoft.com> wrote in message
> > >> >> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> > >> >> > I have trouble with it. I have tried several ways and talked to some people
> > >> >> > in the forum, but it is not working. The following is waht I did.
> > >> >> >
> > >> >> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> > >> >> > and machine name\my login name.
> > >> >> > (2) Copy backup file to another machine with SQL Server 2005.
> > >> >> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > >> >> > (4) Use Restore to restore the backup to a database.
> > >> >> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> > >> >> > work.
> > >> >> > the error massage. I can not either display the diagram or create new
> > >> >> > diagram on the database. The error message:
> > >> >> > "Database diagram support objects cannot be installed because this database
> > >> >> > does not have valid owner.
> > >> >> > To continue, first use the Files page of the Database Properties dialog box
> > >> >> > ot the Alter Authorization statement
> > >> >> > to set the database owner to a valid login, then add the datatbase diagram
> > >> >> > support objects."
> > >> >> >
> > >> >> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> > >> >> > For compatiable, run
> > >> >> > exec sp_dbcmptlevel 'database_name', '90';
> > >> >> > It is OK for exec.
> > >> >> > For alter authorization, run
> > >> >> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> > >> >> >
> > >> >> > This produces an error: 15151
> > >> >> >
> > >> >> > Are there any tricks in backup and restore process?
> > >> >> >
> > >> >> > Thank you for any help.
> > >> >> >
> > >> >> > David
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >>
> > >>
> > >>
> >|||I used
ALTER AUTHORIZATION on DATABASE::databasename TO 'new_machine_name\Firstname
Lastname'
and I get error:
incorrect syntax near 'new_machine_name\Firstname Lastname' .
If I use
ALTER AUTHORIZATION on DATABASE::databasename TO new_machine_name\Firstname
Lastname
I fet error: incorrect syntax near '\'
David
"david" wrote:
> Thank you.
> so my login name in new machine should be (under sqlserver\security\logins:
> new_machine_name\Firstname Lastname (a sapce between them)
> So I should use
> ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
> Lastname
> Now I get error:
> incorrect syntax near 'new_machine_name'.
> How to correct it?
> David
> "Tibor Karaszi" wrote:
> > No, under the server node (the root node), in the security folder.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://sqlblog.com/blogs/tibor_karaszi
> >
> >
> > "david" <david@.discussions.microsoft.com> wrote in message
> > news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...
> > > Is a lohin name displayed under security under databases tree node?
> > >
> > > David
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > >> > Should 'valid_login' be a user name?
> > >>
> > >> No, it should be a login name. If you don't know the difference between a login and a user, I
> > >> strongly suggest you read up on the subject. Here's a good start:
> > >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
> > >>
> > >> --
> > >> Tibor Karaszi, SQL Server MVP
> > >> http://www.karaszi.com/sqlserver/default.asp
> > >> http://sqlblog.com/blogs/tibor_karaszi
> > >>
> > >>
> > >> "david" <david@.discussions.microsoft.com> wrote in message
> > >> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
> > >> > Can not find the principal 'valid_login', because it does not exist.
> > >> >
> > >> > Should 'valid_login' be a user name?
> > >> >
> > >> > How to create a correct user name?
> > >> >
> > >> > I created one, and use the username instead of 'valid_login' and got same
> > >> > error.
> > >> >
> > >> > David
> > >> >
> > >> > "Tibor Karaszi" wrote:
> > >> >
> > >> >> > This produces an error: 15151
> > >> >>
> > >> >> Can you show us the error message and not only the error number?
> > >> >>
> > >> >> --
> > >> >> Tibor Karaszi, SQL Server MVP
> > >> >> http://www.karaszi.com/sqlserver/default.asp
> > >> >> http://sqlblog.com/blogs/tibor_karaszi
> > >> >>
> > >> >>
> > >> >> "david" <david@.discussions.microsoft.com> wrote in message
> > >> >> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> > >> >> > I have trouble with it. I have tried several ways and talked to some people
> > >> >> > in the forum, but it is not working. The following is waht I did.
> > >> >> >
> > >> >> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> > >> >> > and machine name\my login name.
> > >> >> > (2) Copy backup file to another machine with SQL Server 2005.
> > >> >> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > >> >> > (4) Use Restore to restore the backup to a database.
> > >> >> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> > >> >> > work.
> > >> >> > the error massage. I can not either display the diagram or create new
> > >> >> > diagram on the database. The error message:
> > >> >> > "Database diagram support objects cannot be installed because this database
> > >> >> > does not have valid owner.
> > >> >> > To continue, first use the Files page of the Database Properties dialog box
> > >> >> > ot the Alter Authorization statement
> > >> >> > to set the database owner to a valid login, then add the datatbase diagram
> > >> >> > support objects."
> > >> >> >
> > >> >> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> > >> >> > For compatiable, run
> > >> >> > exec sp_dbcmptlevel 'database_name', '90';
> > >> >> > It is OK for exec.
> > >> >> > For alter authorization, run
> > >> >> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> > >> >> >
> > >> >> > This produces an error: 15151
> > >> >> >
> > >> >> > Are there any tricks in backup and restore process?
> > >> >> >
> > >> >> > Thank you for any help.
> > >> >> >
> > >> >> > David
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >>
> > >>
> > >>
> >|||Thank you
It works when I use double qoutes.
David
"david" wrote:
> I used
> ALTER AUTHORIZATION on DATABASE::databasename TO 'new_machine_name\Firstname
> Lastname'
> and I get error:
> incorrect syntax near 'new_machine_name\Firstname Lastname' .
> If I use
> ALTER AUTHORIZATION on DATABASE::databasename TO new_machine_name\Firstname
> Lastname
> I fet error: incorrect syntax near '\'
> David
> "david" wrote:
> > Thank you.
> > so my login name in new machine should be (under sqlserver\security\logins:
> >
> > new_machine_name\Firstname Lastname (a sapce between them)
> >
> > So I should use
> >
> > ALTER AUTHORIZATION on DATABASE::databasename new_machine_name\Firstname
> > Lastname
> >
> > Now I get error:
> > incorrect syntax near 'new_machine_name'.
> >
> > How to correct it?
> >
> > David
> >
> > "Tibor Karaszi" wrote:
> >
> > > No, under the server node (the root node), in the security folder.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://sqlblog.com/blogs/tibor_karaszi
> > >
> > >
> > > "david" <david@.discussions.microsoft.com> wrote in message
> > > news:65951F87-DC9D-4CC9-8819-896924752E32@.microsoft.com...
> > > > Is a lohin name displayed under security under databases tree node?
> > > >
> > > > David
> > > >
> > > > "Tibor Karaszi" wrote:
> > > >
> > > >> > Should 'valid_login' be a user name?
> > > >>
> > > >> No, it should be a login name. If you don't know the difference between a login and a user, I
> > > >> strongly suggest you read up on the subject. Here's a good start:
> > > >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm
> > > >>
> > > >> --
> > > >> Tibor Karaszi, SQL Server MVP
> > > >> http://www.karaszi.com/sqlserver/default.asp
> > > >> http://sqlblog.com/blogs/tibor_karaszi
> > > >>
> > > >>
> > > >> "david" <david@.discussions.microsoft.com> wrote in message
> > > >> news:6FFF5FBA-3E01-46AC-982C-B60CE88DD66F@.microsoft.com...
> > > >> > Can not find the principal 'valid_login', because it does not exist.
> > > >> >
> > > >> > Should 'valid_login' be a user name?
> > > >> >
> > > >> > How to create a correct user name?
> > > >> >
> > > >> > I created one, and use the username instead of 'valid_login' and got same
> > > >> > error.
> > > >> >
> > > >> > David
> > > >> >
> > > >> > "Tibor Karaszi" wrote:
> > > >> >
> > > >> >> > This produces an error: 15151
> > > >> >>
> > > >> >> Can you show us the error message and not only the error number?
> > > >> >>
> > > >> >> --
> > > >> >> Tibor Karaszi, SQL Server MVP
> > > >> >> http://www.karaszi.com/sqlserver/default.asp
> > > >> >> http://sqlblog.com/blogs/tibor_karaszi
> > > >> >>
> > > >> >>
> > > >> >> "david" <david@.discussions.microsoft.com> wrote in message
> > > >> >> news:5494E0D2-1097-476A-8C00-45FCE60DA67A@.microsoft.com...
> > > >> >> > I have trouble with it. I have tried several ways and talked to some people
> > > >> >> > in the forum, but it is not working. The following is waht I did.
> > > >> >> >
> > > >> >> > (1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
> > > >> >> > and machine name\my login name.
> > > >> >> > (2) Copy backup file to another machine with SQL Server 2005.
> > > >> >> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > >> >> > (4) Use Restore to restore the backup to a database.
> > > >> >> > (5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
> > > >> >> > work.
> > > >> >> > the error massage. I can not either display the diagram or create new
> > > >> >> > diagram on the database. The error message:
> > > >> >> > "Database diagram support objects cannot be installed because this database
> > > >> >> > does not have valid owner.
> > > >> >> > To continue, first use the Files page of the Database Properties dialog box
> > > >> >> > ot the Alter Authorization statement
> > > >> >> > to set the database owner to a valid login, then add the datatbase diagram
> > > >> >> > support objects."
> > > >> >> >
> > > >> >> > I do not know the detail steps for doing it. In the MSDN, it suggests that
> > > >> >> > For compatiable, run
> > > >> >> > exec sp_dbcmptlevel 'database_name', '90';
> > > >> >> > It is OK for exec.
> > > >> >> > For alter authorization, run
> > > >> >> > ALTER AUTHORIZATION ON DATABASE::databasename to valid_login
> > > >> >> >
> > > >> >> > This produces an error: 15151
> > > >> >> >
> > > >> >> > Are there any tricks in backup and restore process?
> > > >> >> >
> > > >> >> > Thank you for any help.
> > > >> >> >
> > > >> >> > David
> > > >> >> >
> > > >> >> >
> > > >> >> >
> > > >> >>
> > > >>
> > > >>
> > >|||hey dude its quiet easy just
only a single change will do what you want
open your database properties
choose options, next change 'compatability level' to SQL Server 2005(90)
hit on ok
and keep going BOL ^^^
*** Sent via Developersdex http://www.developersdex.com ***