Showing posts with label script. Show all posts
Showing posts with label script. Show all posts

Thursday, March 22, 2012

Error 8115

While trying to create script for database following error appeared:
An error occurrred during scripting.
Error 8115: Arithmatic overflow error converting expression to data type int
.
Database is SQL 7 and the Enterpriser Manager I am using is SQL 2000.
Any help will be appreciatedHave you tried to create the script using a 7.0 Enterprise Manager Client?
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:C43596C9-7FF0-4E1C-93B8-2840F29DA0F2@.microsoft.com...
> While trying to create script for database following error appeared:
> An error occurrred during scripting.
> Error 8115: Arithmatic overflow error converting expression to data type
int.
> Database is SQL 7 and the Enterpriser Manager I am using is SQL 2000.
> Any help will be appreciated|||I have not tried yet, but I can generate script for another database residin
g
on same sql 7 server, using SQL 2000 client.
"Gregory A. Larsen" wrote:

> Have you tried to create the script using a 7.0 Enterprise Manager Client?
> "SB138" <SB138@.discussions.microsoft.com> wrote in message
> news:C43596C9-7FF0-4E1C-93B8-2840F29DA0F2@.microsoft.com...
> int.
>
>sql

Error 8115

While trying to create script for database following error appeared:
An error occurrred during scripting.
Error 8115: Arithmatic overflow error converting expression to data type int.
Database is SQL 7 and the Enterpriser Manager I am using is SQL 2000.
Any help will be appreciated
Have you tried to create the script using a 7.0 Enterprise Manager Client?
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:C43596C9-7FF0-4E1C-93B8-2840F29DA0F2@.microsoft.com...
> While trying to create script for database following error appeared:
> An error occurrred during scripting.
> Error 8115: Arithmatic overflow error converting expression to data type
int.
> Database is SQL 7 and the Enterpriser Manager I am using is SQL 2000.
> Any help will be appreciated
|||I have not tried yet, but I can generate script for another database residing
on same sql 7 server, using SQL 2000 client.
"Gregory A. Larsen" wrote:

> Have you tried to create the script using a 7.0 Enterprise Manager Client?
> "SB138" <SB138@.discussions.microsoft.com> wrote in message
> news:C43596C9-7FF0-4E1C-93B8-2840F29DA0F2@.microsoft.com...
> int.
>
>

Wednesday, March 21, 2012

Error 7399

Here is my code:

/*--

--

-- Cape Hatteras Adventures v.2 sample database - Populate

-- Paul Nielsen

-- this script will populate the CHA2 database

-- from CHA1_Customers.mdb Access file

-- and CHA1_Schedule.xls Excel Spreadsheet

-- using distributed queries

--

--

USE CHA2

-- establish Access Linked Server

EXECsp_DropServer @.server ='CHA1_Customers'

go

EXECsp_addlinkedserver

'CHA1_Customers',

'Access 2003',

'Microsoft.Jet.OLEDB.4.0',

'C:\SQLData\CHA1_Customers.mdb'

go

-- establish Excel Linked Server

EXECsp_DropServer @.server ='CHA1_Schedule'

go

Executesp_addlinkedserver

'CHA1_Schedule',

'Excel',

'Microsoft.Jet.OLEDB.4.0',

'C:\SQLData\CHA1_Schedule.xls',

NULL,

'Excel 5.0'

go

EXECsp_helpserver

-- Step 0: Initialize the Database

DELETE Customer

DELETE CustomerType

DELETE Event_mm_Customer

DELETE Event_mm_Guide

DELETE Tour_mm_Guide

DELETEEvent

DELETE Tour

DELETE BaseCamp

DELETE Guide

-- Step 1: Customer Types

SELECTDISTINCT CustomerType

FROM CHA1_Customers...Customers

WHERE CustomerType ISNOTNULL

INSERT CustomerType(Name)

SELECTDISTINCT CustomerType

FROM CHA1_Customers...Customers

WHERE CustomerType ISNOTNULL

SELECT*FROM CustomerType

-- Step 2: Customers

SELECTDISTINCT ContactLastName, ContactFirstName, CustomerType

FROM CHA1_Customers...Customers

WHERE ContactLastName ISNOTNULL

SELECT*FROM CustomerType

SELECT*FROM CHA1_Customers...Customers

INSERT Customer(LastName, FirstName, CustomerTypeID,Address,

City,Country, eMail, NickName,FirstTour, Medical)

SELECTDISTINCT ContactLastName, ContactFirstName, CustomerTypeID,BillingAddress,

City, Country, EMailAddress,NickName, FirstTour, HealthIssues

FROM CHA1_Customers...Customers C

LEFTOUTERJOIN CustomerType

ON C.CustomerType = CustomerType.[Name]

WHERE ContactLastName ISNOTNULL

SELECT*FROM Customer

-- Step 3: Base Camps

INSERT BaseCamp(Name)

SELECTDISTINCT [Base Camp]

FROM CHA1_Schedule...[Base_Camp]

WHERE [Base Camp] ISNOTNULL

SELECT*FROM BaseCamp

-- Step 4: Tours

INSERT Tour ([Name], BaseCampID)

SELECTDISTINCT Tour, BaseCampID

FROM CHA1_Schedule...Tour X

JOIN BaseCamp

ON X.[Base Camp] = BaseCamp.Name

WHERE Tour ISNOTNULL

SELECT*FROM Tour

-- Step 5: Guides

INSERT Guide(FirstName, LastName)

SELECTDISTINCT

LEFT([Lead Guide],CharIndex(' ', [Lead Guide])-1),

RIGHT([Lead Guide],Len([Lead Guide])-CharIndex(' ', [Lead Guide]))

FROM CHA1_Schedule...Lead_Guide

WHERE [Lead Guide] ISNOTNULL

SELECT*FROM Guide

-- Step 6: Events

SELECTDISTINCT*

FROM CHA1_Schedule...Event

SELECT*FROMEvent

INSERTEvent(TourID, DateBegin, Code)

SELECTDISTINCT Tour.TourID, [Date], EventCode

FROM CHA1_Schedule...Event X

JOIN Tour

ON X.Tour = Tour.Name

-- Step 7: Event_mm_Customer

SELECT*FROM Event_mm_Customer

INSERT Event_mm_Customer(CustomerID, EventID)

SELECTDISTINCT Customer.CustomerID, Event.EventID

FROM CHA1_Schedule...Customer X

JOIN Customer

ON X.LastName = Customer.LastName

AND X.FirstName = Customer.FirstName

JOINEvent

ON X.EventCode = Event.Code

-- Step 8: Event_mm_Guide

SELECT*FROM Event_mm_Guide

INSERT Event_mm_Guide(EventID, GuideID, IsLead)

SELECTDISTINCT Event.EventID, Guide.GuideID, 1

FROM CHA1_Schedule...Event X

JOIN Guide

ON X.[Lead Guide] = Guide.FirstName +' '+ Guide.LastName

JOINEvent

ON X.EventCode = Event.Code

-- Step 9: Tour_mm_Guide

INSERT Tour_mm_Guide (TourID, GuideID, QualDate)

SELECTDISTINCT Tour.TourID, Event_mm_Guide.GuideID,'1/1/2000'

FROM Tour

JOINEvent

ON Event.TourID = Tour.TourID

JOIN Event_mm_Guide

ON Event.EventID = Event_mm_Guide.EventID

SELECT*FROM Tour_mm_Guide

Select*from vTableRowCount

-*/

Here is my error: What's happeniing here?

/*--

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CHA1_Customers" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

Msg 7399, Level 16, State 1, Line 16

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CHA1_Customers" reported an error. Authentication failed.

Msg 7303, Level 16, State 1, Line 16

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CHA1_Customers".

*/

It looks like your Access db is opened in exclusive mode and/or the userid/password you're providing are incorrect.

Sunday, February 26, 2012

Error 3013

Got a weird one...
I have 20 databases on one SQL 2000 sp4, .2187 instance.
I also have a backup database and backup log script that I run, which
enumerates the datbase list and runs a backup for each one.
One specific database errors, while the ones before and after it succeed.
It used to work just fine, no changes (especially since I can pinpoint the
failure time to 5:50am, and I know nobody was fooling with the server at
that time).
The error is 3013 - "Backup terminating abnormally" (not the verbatim
error). Error happens for full backup and t-log.
I cannot backup manually through QA or Enterprise manger either. Nor can I
backup to a different location one the same or different drives...
Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in the
\LOG folder. Plenty of space on the backup drive, running out on the T-Log
drive...
Help?
Thanks,
Kevin Hill
3NF Consulting
http://kevinbhill.powweb.com/NewsGroups.htm
My random SQL Server encounters:
http://kevin3nf.blogspot.com/
Forgot to mention that DBCC CheckAlloc and DBCC CheckDB come up clean
"Kevin3NF" <Kevin@.DontSpamMe3NF-inc.com> wrote in message
news:%23Qybs8kFHHA.1080@.TK2MSFTNGP05.phx.gbl...
> Got a weird one...
> I have 20 databases on one SQL 2000 sp4, .2187 instance.
> I also have a backup database and backup log script that I run, which
> enumerates the datbase list and runs a backup for each one.
> One specific database errors, while the ones before and after it succeed.
> It used to work just fine, no changes (especially since I can pinpoint the
> failure time to 5:50am, and I know nobody was fooling with the server at
> that time).
> The error is 3013 - "Backup terminating abnormally" (not the verbatim
> error). Error happens for full backup and t-log.
> I cannot backup manually through QA or Enterprise manger either. Nor can
> I backup to a different location one the same or different drives...
> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in
> the \LOG folder. Plenty of space on the backup drive, running out on the
> T-Log drive...
> Help?
> Thanks,
> Kevin Hill
> 3NF Consulting
> http://kevinbhill.powweb.com/NewsGroups.htm
> My random SQL Server encounters:
> http://kevin3nf.blogspot.com/
>
>
>
|||Kevin3NF wrote:
> Got a weird one...
> I have 20 databases on one SQL 2000 sp4, .2187 instance.
> I also have a backup database and backup log script that I run, which
> enumerates the datbase list and runs a backup for each one.
> One specific database errors, while the ones before and after it succeed.
> It used to work just fine, no changes (especially since I can pinpoint the
> failure time to 5:50am, and I know nobody was fooling with the server at
> that time).
> The error is 3013 - "Backup terminating abnormally" (not the verbatim
> error). Error happens for full backup and t-log.
> I cannot backup manually through QA or Enterprise manger either. Nor can I
> backup to a different location one the same or different drives...
> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in the
> \LOG folder. Plenty of space on the backup drive, running out on the T-Log
> drive...
> Help?
> Thanks,
> Kevin Hill
> 3NF Consulting
> http://kevinbhill.powweb.com/NewsGroups.htm
> My random SQL Server encounters:
> http://kevin3nf.blogspot.com/
>
>
>
Anything in the error log?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Just backup failed
Customer has since changed the db to Simple, and now we cannot change it
back to FULL (3013 and 5069)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45742818.40402@.realsqlguy.com...
> Kevin3NF wrote:
> Anything in the error log?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Kevin3NF wrote:
> Just backup failed
> Customer has since changed the db to Simple, and now we cannot change it
> back to FULL (3013 and 5069)
>
- Are you able to run queries against this database?
- Are you able to modify data within this database?
- Is something (tape backup, anti-virus software) preventing SQL from
writing to the MDF or LDF file?
- Does the SQL Server service account have proper rights to the MDF and
LDF files?
This sounds to me like something is restricting writes to the
transaction log file...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||See below...everything appears to be working normally except the backups
This database is a replication publisher and that process is working just
fine..
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45743322.7040206@.realsqlguy.com...
> Kevin3NF wrote:
> - Are you able to run queries against this database?
Yes
> - Are you able to modify data within this database?
Yes
> - Is something (tape backup, anti-virus software) preventing SQL from
> writing to the MDF or LDF file?
Not that I am aware of...failures have been happening since 11/30
> - Does the SQL Server service account have proper rights to the MDF and
> LDF files?
Yes
> This sounds to me like something is restricting writes to the transaction
> log file...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Everything else has failed, so we aer using DTS to send everything to a new
database...
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45743322.7040206@.realsqlguy.com...
> Kevin3NF wrote:
> - Are you able to run queries against this database?
> - Are you able to modify data within this database?
> - Is something (tape backup, anti-virus software) preventing SQL from
> writing to the MDF or LDF file?
> - Does the SQL Server service account have proper rights to the MDF and
> LDF files?
> This sounds to me like something is restricting writes to the transaction
> log file...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Error 3013

Got a weird one...
I have 20 databases on one SQL 2000 sp4, .2187 instance.
I also have a backup database and backup log script that I run, which
enumerates the datbase list and runs a backup for each one.
One specific database errors, while the ones before and after it succeed.
It used to work just fine, no changes (especially since I can pinpoint the
failure time to 5:50am, and I know nobody was fooling with the server at
that time).
The error is 3013 - "Backup terminating abnormally" (not the verbatim
error). Error happens for full backup and t-log.
I cannot backup manually through QA or Enterprise manger either. Nor can I
backup to a different location one the same or different drives...
Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in the
\LOG folder. Plenty of space on the backup drive, running out on the T-Log
drive...
Help?
Thanks,
Kevin Hill
3NF Consulting
http://kevinbhill.powweb.com/NewsGroups.htm
My random SQL Server encounters:
http://kevin3nf.blogspot.com/Forgot to mention that DBCC CheckAlloc and DBCC CheckDB come up clean
"Kevin3NF" <Kevin@.DontSpamMe3NF-inc.com> wrote in message
news:%23Qybs8kFHHA.1080@.TK2MSFTNGP05.phx.gbl...
> Got a weird one...
> I have 20 databases on one SQL 2000 sp4, .2187 instance.
> I also have a backup database and backup log script that I run, which
> enumerates the datbase list and runs a backup for each one.
> One specific database errors, while the ones before and after it succeed.
> It used to work just fine, no changes (especially since I can pinpoint the
> failure time to 5:50am, and I know nobody was fooling with the server at
> that time).
> The error is 3013 - "Backup terminating abnormally" (not the verbatim
> error). Error happens for full backup and t-log.
> I cannot backup manually through QA or Enterprise manger either. Nor can
> I backup to a different location one the same or different drives...
> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in
> the \LOG folder. Plenty of space on the backup drive, running out on the
> T-Log drive...
> Help?
> Thanks,
> Kevin Hill
> 3NF Consulting
> http://kevinbhill.powweb.com/NewsGroups.htm
> My random SQL Server encounters:
> http://kevin3nf.blogspot.com/
>
>
>|||Kevin3NF wrote:
> Got a weird one...
> I have 20 databases on one SQL 2000 sp4, .2187 instance.
> I also have a backup database and backup log script that I run, which
> enumerates the datbase list and runs a backup for each one.
> One specific database errors, while the ones before and after it succeed.
> It used to work just fine, no changes (especially since I can pinpoint the
> failure time to 5:50am, and I know nobody was fooling with the server at
> that time).
> The error is 3013 - "Backup terminating abnormally" (not the verbatim
> error). Error happens for full backup and t-log.
> I cannot backup manually through QA or Enterprise manger either. Nor can
I
> backup to a different location one the same or different drives...
> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in t
he
> \LOG folder. Plenty of space on the backup drive, running out on the T-Lo
g
> drive...
> Help?
> Thanks,
> Kevin Hill
> 3NF Consulting
> http://kevinbhill.powweb.com/NewsGroups.htm
> My random SQL Server encounters:
> http://kevin3nf.blogspot.com/
>
>
>
Anything in the error log?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Just backup failed
Customer has since changed the db to Simple, and now we cannot change it
back to FULL (3013 and 5069)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45742818.40402@.realsqlguy.com...
> Kevin3NF wrote:
> Anything in the error log?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Kevin3NF wrote:
> Just backup failed
> Customer has since changed the db to Simple, and now we cannot change it
> back to FULL (3013 and 5069)
>
- Are you able to run queries against this database?
- Are you able to modify data within this database?
- Is something (tape backup, anti-virus software) preventing SQL from
writing to the MDF or LDF file?
- Does the SQL Server service account have proper rights to the MDF and
LDF files?
This sounds to me like something is restricting writes to the
transaction log file...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||See below...everything appears to be working normally except the backups
This database is a replication publisher and that process is working just
fine..
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45743322.7040206@.realsqlguy.com...
> Kevin3NF wrote:
> - Are you able to run queries against this database?
Yes
> - Are you able to modify data within this database?
Yes
> - Is something (tape backup, anti-virus software) preventing SQL from
> writing to the MDF or LDF file?
Not that I am aware of...failures have been happening since 11/30
> - Does the SQL Server service account have proper rights to the MDF and
> LDF files?
Yes
> This sounds to me like something is restricting writes to the transaction
> log file...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Everything else has failed, so we aer using DTS to send everything to a new
database...
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45743322.7040206@.realsqlguy.com...
> Kevin3NF wrote:
> - Are you able to run queries against this database?
> - Are you able to modify data within this database?
> - Is something (tape backup, anti-virus software) preventing SQL from
> writing to the MDF or LDF file?
> - Does the SQL Server service account have proper rights to the MDF and
> LDF files?
> This sounds to me like something is restricting writes to the transaction
> log file...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Error 3013

Got a weird one...
I have 20 databases on one SQL 2000 sp4, .2187 instance.
I also have a backup database and backup log script that I run, which
enumerates the datbase list and runs a backup for each one.
One specific database errors, while the ones before and after it succeed.
It used to work just fine, no changes (especially since I can pinpoint the
failure time to 5:50am, and I know nobody was fooling with the server at
that time).
The error is 3013 - "Backup terminating abnormally" (not the verbatim
error). Error happens for full backup and t-log.
I cannot backup manually through QA or Enterprise manger either. Nor can I
backup to a different location one the same or different drives...
Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in the
\LOG folder. Plenty of space on the backup drive, running out on the T-Log
drive...
Help?
Thanks,
Kevin Hill
3NF Consulting
http://kevinbhill.powweb.com/NewsGroups.htm
My random SQL Server encounters:
http://kevin3nf.blogspot.com/Forgot to mention that DBCC CheckAlloc and DBCC CheckDB come up clean
"Kevin3NF" <Kevin@.DontSpamMe3NF-inc.com> wrote in message
news:%23Qybs8kFHHA.1080@.TK2MSFTNGP05.phx.gbl...
> Got a weird one...
> I have 20 databases on one SQL 2000 sp4, .2187 instance.
> I also have a backup database and backup log script that I run, which
> enumerates the datbase list and runs a backup for each one.
> One specific database errors, while the ones before and after it succeed.
> It used to work just fine, no changes (especially since I can pinpoint the
> failure time to 5:50am, and I know nobody was fooling with the server at
> that time).
> The error is 3013 - "Backup terminating abnormally" (not the verbatim
> error). Error happens for full backup and t-log.
> I cannot backup manually through QA or Enterprise manger either. Nor can
> I backup to a different location one the same or different drives...
> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in
> the \LOG folder. Plenty of space on the backup drive, running out on the
> T-Log drive...
> Help?
> Thanks,
> Kevin Hill
> 3NF Consulting
> http://kevinbhill.powweb.com/NewsGroups.htm
> My random SQL Server encounters:
> http://kevin3nf.blogspot.com/
>
>
>|||Kevin3NF wrote:
> Got a weird one...
> I have 20 databases on one SQL 2000 sp4, .2187 instance.
> I also have a backup database and backup log script that I run, which
> enumerates the datbase list and runs a backup for each one.
> One specific database errors, while the ones before and after it succeed.
> It used to work just fine, no changes (especially since I can pinpoint the
> failure time to 5:50am, and I know nobody was fooling with the server at
> that time).
> The error is 3013 - "Backup terminating abnormally" (not the verbatim
> error). Error happens for full backup and t-log.
> I cannot backup manually through QA or Enterprise manger either. Nor can I
> backup to a different location one the same or different drives...
> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in the
> \LOG folder. Plenty of space on the backup drive, running out on the T-Log
> drive...
> Help?
> Thanks,
> Kevin Hill
> 3NF Consulting
> http://kevinbhill.powweb.com/NewsGroups.htm
> My random SQL Server encounters:
> http://kevin3nf.blogspot.com/
>
>
>
Anything in the error log?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Just backup failed
Customer has since changed the db to Simple, and now we cannot change it
back to FULL (3013 and 5069)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45742818.40402@.realsqlguy.com...
> Kevin3NF wrote:
>> Got a weird one...
>> I have 20 databases on one SQL 2000 sp4, .2187 instance.
>> I also have a backup database and backup log script that I run, which
>> enumerates the datbase list and runs a backup for each one.
>> One specific database errors, while the ones before and after it succeed.
>> It used to work just fine, no changes (especially since I can pinpoint
>> the failure time to 5:50am, and I know nobody was fooling with the server
>> at that time).
>> The error is 3013 - "Backup terminating abnormally" (not the verbatim
>> error). Error happens for full backup and t-log.
>> I cannot backup manually through QA or Enterprise manger either. Nor can
>> I backup to a different location one the same or different drives...
>> Tried to generate a mini-dump using DBCC DUMPTRIGGER, but got nothing in
>> the \LOG folder. Plenty of space on the backup drive, running out on the
>> T-Log drive...
>> Help?
>> Thanks,
>> Kevin Hill
>> 3NF Consulting
>> http://kevinbhill.powweb.com/NewsGroups.htm
>> My random SQL Server encounters:
>> http://kevin3nf.blogspot.com/
>>
>>
> Anything in the error log?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Kevin3NF wrote:
> Just backup failed
> Customer has since changed the db to Simple, and now we cannot change it
> back to FULL (3013 and 5069)
>
- Are you able to run queries against this database?
- Are you able to modify data within this database?
- Is something (tape backup, anti-virus software) preventing SQL from
writing to the MDF or LDF file?
- Does the SQL Server service account have proper rights to the MDF and
LDF files?
This sounds to me like something is restricting writes to the
transaction log file...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||See below...everything appears to be working normally except the backups
This database is a replication publisher and that process is working just
fine..
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45743322.7040206@.realsqlguy.com...
> Kevin3NF wrote:
>> Just backup failed
>> Customer has since changed the db to Simple, and now we cannot change it
>> back to FULL (3013 and 5069)
> - Are you able to run queries against this database?
Yes
> - Are you able to modify data within this database?
Yes
> - Is something (tape backup, anti-virus software) preventing SQL from
> writing to the MDF or LDF file?
Not that I am aware of...failures have been happening since 11/30
> - Does the SQL Server service account have proper rights to the MDF and
> LDF files?
Yes
> This sounds to me like something is restricting writes to the transaction
> log file...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Everything else has failed, so we aer using DTS to send everything to a new
database...
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45743322.7040206@.realsqlguy.com...
> Kevin3NF wrote:
>> Just backup failed
>> Customer has since changed the db to Simple, and now we cannot change it
>> back to FULL (3013 and 5069)
> - Are you able to run queries against this database?
> - Are you able to modify data within this database?
> - Is something (tape backup, anti-virus software) preventing SQL from
> writing to the MDF or LDF file?
> - Does the SQL Server service account have proper rights to the MDF and
> LDF files?
> This sounds to me like something is restricting writes to the transaction
> log file...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Friday, February 17, 2012

Error 21776 [SQL DMO]

HELLO,
I have a bunch of users I need to change their defult db's and grant access
to that db, so I run the following script:
EXEC sp_defaultdb 'CGallego' , 'CRCS'
exec sp_grantdbaccess 'CGallego', 'CGallego'
When I go into EM to view their properties, I get the following error message:
Error 21776 [SQL DMO] The name 'CGallego' was not found in the Users
Collection.
If the name is a qualified name use [] to seprate the various parts of the
name.
How can I resolve this issue. Thanks.
--
New SQL Server DBAHi,
Looks like the database owner for CRCS database is not available in
syslogins table. Did you restored this database from any other server.
If yes then the Login may not be there in Syslogins table. In that case
change the database owner using the stored procedure sp_changedbowner (see
books online for the usage)
Thanks
hari
SQL Server MVP
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:60DAE6E4-8738-42AD-A44B-D4639BE8501D@.microsoft.com...
> HELLO,
> I have a bunch of users I need to change their defult db's and grant
> access
> to that db, so I run the following script:
> EXEC sp_defaultdb 'CGallego' , 'CRCS'
> exec sp_grantdbaccess 'CGallego', 'CGallego'
> When I go into EM to view their properties, I get the following error
> message:
> Error 21776 [SQL DMO] The name 'CGallego' was not found in the Users
> Collection.
> If the name is a qualified name use [] to seprate the various parts of the
> name.
> How can I resolve this issue. Thanks.
> --
> New SQL Server DBA|||The owner of the db is sa and is in the syslogins table.
--
New SQL Server DBA
"Hari Prasad" wrote:
> Hi,
> Looks like the database owner for CRCS database is not available in
> syslogins table. Did you restored this database from any other server.
> If yes then the Login may not be there in Syslogins table. In that case
> change the database owner using the stored procedure sp_changedbowner (see
> books online for the usage)
> Thanks
> hari
> SQL Server MVP
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:60DAE6E4-8738-42AD-A44B-D4639BE8501D@.microsoft.com...
> > HELLO,
> >
> > I have a bunch of users I need to change their defult db's and grant
> > access
> > to that db, so I run the following script:
> >
> > EXEC sp_defaultdb 'CGallego' , 'CRCS'
> > exec sp_grantdbaccess 'CGallego', 'CGallego'
> >
> > When I go into EM to view their properties, I get the following error
> > message:
> >
> > Error 21776 [SQL DMO] The name 'CGallego' was not found in the Users
> > Collection.
> > If the name is a qualified name use [] to seprate the various parts of the
> > name.
> >
> > How can I resolve this issue. Thanks.
> > --
> > New SQL Server DBA
>
>|||make sure CGallego is a valid SQL login first..
Then perhaps try to do sp_grantdbaccess first, then defaultdb..
also check sp_helpuser... Perhaps the sps are working properly,but you are
having trouble with SEM which is not related to your scripts.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:60DAE6E4-8738-42AD-A44B-D4639BE8501D@.microsoft.com...
> HELLO,
> I have a bunch of users I need to change their defult db's and grant
> access
> to that db, so I run the following script:
> EXEC sp_defaultdb 'CGallego' , 'CRCS'
> exec sp_grantdbaccess 'CGallego', 'CGallego'
> When I go into EM to view their properties, I get the following error
> message:
> Error 21776 [SQL DMO] The name 'CGallego' was not found in the Users
> Collection.
> If the name is a qualified name use [] to seprate the various parts of the
> name.
> How can I resolve this issue. Thanks.
> --
> New SQL Server DBA