DBCC CHECKDB: write

Showing posts with label write. Show all posts

Thursday, March 29, 2012

DB2 Write Image to Blob field

I need some help in SSIS Package I am trying to write a byte array to an image (blob) in DB2 destination. I am getting SQL code -290 Invalid Description, if i set the output column to a byte stream. If I set the output column to an Image data type then I get a different error the package will not at that time even process it errors out right away. At least using a byte stream datatype it errors out when it is about to write to the olebd destination. Anybody have success using BLOB fields in SSIS package data flow? Thanks for any help.

What provider you used for DB2? I have a memory that the Microsoft OLEDB provider for DB2 does not support retrieve LOB type columns, inside SSIS, yet. Please confirm with the version release note you installed on your computer if that's what you used.

thanks

wenyang

|||Are you using IBM DB2 .NET Data Provider? If not, get it as part of the IBM DB2 Clinet from https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db2client|||

Wenyang Hu wrote:

What provider you used for DB2? I have a memory that the Microsoft OLEDB provider for DB2 does not support retrieve LOB type columns, inside SSIS, yet. Please confirm with the version release note you installed on your computer if that's what you used.
thanks
wenyang

Do you know when this will be fixed?|||I am using the Microsoft OLE DB provider for DB2, I am not using the .net version.

Wednesday, March 21, 2012

db rights

How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB? How do you set up a DBA user other than sa?
Hi,
How do you set up a DBA user other than sa?
Assign the "SYSADMIN" server fixed role to that user using the below command
sp_addsrvrolemember <Logsin Name>,sysadmin
How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB?
Assign "db_backupoperator" to user. This will allow users to backup not
restore. Restore database permission can not be granted.
sp_addrolemember 'db_backupoperator',<User Name>
If you assign the server fixed "dbcreator" role. The user will be able to
Backup, restore , create database, drop database and alter database.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:unI8kgNKEHA.1144@.TK2MSFTNGP12.phx.gbl...
> How do you set up an user which can do backup and restore DB but do not
have
> read or write right to that DB? How do you set up a DBA user other than
sa?
>

db rights

How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB? How do you set up a DBA user other than sa?Hi,
How do you set up a DBA user other than sa?
Assign the "SYSADMIN" server fixed role to that user using the below command
sp_addsrvrolemember <Logsin Name>,sysadmin
How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB?
Assign "db_backupoperator" to user. This will allow users to backup not
restore. Restore database permission can not be granted.
sp_addrolemember 'db_backupoperator',<User Name>
If you assign the server fixed "dbcreator" role. The user will be able to
Backup, restore , create database, drop database and alter database.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:unI8kgNKEHA.1144@.TK2MSFTNGP12.phx.gbl...
> How do you set up an user which can do backup and restore DB but do not
have
> read or write right to that DB? How do you set up a DBA user other than
sa?
>

Monday, March 19, 2012

db rights

How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB? How do you set up a DBA user other than sa?Hi,
How do you set up a DBA user other than sa?
Assign the "SYSADMIN" server fixed role to that user using the below command
sp_addsrvrolemember <Logsin Name>,sysadmin
How do you set up an user which can do backup and restore DB but do not have
read or write right to that DB?
Assign "db_backupoperator" to user. This will allow users to backup not
restore. Restore database permission can not be granted.
sp_addrolemember 'db_backupoperator',<User Name>
If you assign the server fixed "dbcreator" role. The user will be able to
Backup, restore , create database, drop database and alter database.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:unI8kgNKEHA.1144@.TK2MSFTNGP12.phx.gbl...
> How do you set up an user which can do backup and restore DB but do not
have
> read or write right to that DB? How do you set up a DBA user other than
sa?
>

DB restore puzzle

Hi friends,
I like to write a program to automate the following time
consuming and tedious task:
A database was full backed up and got pruned to keep one
week worth of data daily. Now I need to build an archive
type database using all the backup files I have since the
beginning of last year. This archive database contains all
the history data, just lile the original database never
gets pruned. How to do it?
My current plan is to:
1. loop through the backup files
2. For each back up file, restore it using "restore DB"
command
3, After each database is restored, load the data into my
archive database
4. loop to next backup file
5. When all the back files have been processed, remove the
duplicate from archive database.
Although I have not tried, I can expect one problem I am
going to run into is that I can not restore the database
in loop because the prior restored database "is in use".
Does anyone have any suggestion?
Thanks a thousand times in advance,
New Bee> Although I have not tried, I can expect one problem I am
> going to run into is that I can not restore the database
> in loop because the prior restored database "is in use".
If you don't have a connection yourself in the db and no users has connections to the db, then you
don't have to worry. If you are worried about users having connections, you can use ALTER DATABASE
to set to single user and the ROLLBACK option to kick out current users.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"New Bee" <anonymous@.discussions.microsoft.com> wrote in message
news:0beb01c397da$ac242320$a301280a@.phx.gbl...
> Hi friends,
> I like to write a program to automate the following time
> consuming and tedious task:
> A database was full backed up and got pruned to keep one
> week worth of data daily. Now I need to build an archive
> type database using all the backup files I have since the
> beginning of last year. This archive database contains all
> the history data, just lile the original database never
> gets pruned. How to do it?
> My current plan is to:
> 1. loop through the backup files
> 2. For each back up file, restore it using "restore DB"
> command
> 3, After each database is restored, load the data into my
> archive database
> 4. loop to next backup file
> 5. When all the back files have been processed, remove the
> duplicate from archive database.
> Although I have not tried, I can expect one problem I am
> going to run into is that I can not restore the database
> in loop because the prior restored database "is in use".
> Does anyone have any suggestion?
> Thanks a thousand times in advance,
> New Bee
>

Sunday, March 11, 2012

DB Recovery Model Type through SQL

Hi,
How to write SQL to find the Recovery Model type.
Please suggest me something.
Thanks, Steven
Which version of SQL Server are you using? For now I'll assume SQL Server
2005, but if that's not it, you'll need to include that as a part of your
question.
SELECT name, recovery_model, recovery_model_desc
FROM sys.databases
-- WHERE name = 'my_database';
"Steven" <Steven@.nospaml.com> wrote in message
news:eEJmOepiIHA.4536@.TK2MSFTNGP06.phx.gbl...
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven
>
|||I always used (on 2K5)
select name, recovery_model, recovery_model_desc from sys.databases
where name=N'DBNAME'
or you can drop the where clause to get them all.
-Sean
On Mar 20, 10:34Xam, "Steven" <Ste...@.nospaml.com> wrote:
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven
|||WOW, that was quick.
This is exactly what I wanted.
Thanks a lot.
Steven.
"Sean" <ColdFusion244@.gmail.com> wrote in message
news:fe305fd3-7dfd-46a3-ae27-0d01a20de40b@.n58g2000hsf.googlegroups.com...
I always used (on 2K5)
select name, recovery_model, recovery_model_desc from sys.databases
where name=N'DBNAME'
or you can drop the where clause to get them all.
-Sean
On Mar 20, 10:34 am, "Steven" <Ste...@.nospaml.com> wrote:
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven

DB Recovery Model Type through SQL

Hi,
How to write SQL to find the Recovery Model type.
Please suggest me something.
Thanks, StevenI always used (on 2K5)
select name, recovery_model, recovery_model_desc from sys.databases
where name=3DN'DBNAME'
or you can drop the where clause to get them all.
-Sean
On Mar 20, 10:34=A0am, "Steven" <Ste...@.nospaml.com> wrote:
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven|||Which version of SQL Server are you using? For now I'll assume SQL Server
2005, but if that's not it, you'll need to include that as a part of your
question.
SELECT name, recovery_model, recovery_model_desc
FROM sys.databases
-- WHERE name = 'my_database';
"Steven" <Steven@.nospaml.com> wrote in message
news:eEJmOepiIHA.4536@.TK2MSFTNGP06.phx.gbl...
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven
>|||WOW, that was quick.
This is exactly what I wanted.
Thanks a lot.
Steven.
"Sean" <ColdFusion244@.gmail.com> wrote in message
news:fe305fd3-7dfd-46a3-ae27-0d01a20de40b@.n58g2000hsf.googlegroups.com...
I always used (on 2K5)
select name, recovery_model, recovery_model_desc from sys.databases
where name=N'DBNAME'
or you can drop the where clause to get them all.
-Sean
On Mar 20, 10:34 am, "Steven" <Ste...@.nospaml.com> wrote:
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven

db permissions in EM

i've got a user that has permissions to read and write in two
databases. that user has enterprise manager installed and uses it (i
know he shouldn't really have it, but that's another topic). he can see
all of the databases on the server. is there any way to make EM only
show him the two databases which he can access?ch
Unfortunatly,NO
"ch" <ch@.dontemailme.com> wrote in message
news:41862283.D2817F00@.dontemailme.com...
> i've got a user that has permissions to read and write in two
> databases. that user has enterprise manager installed and uses it (i
> know he shouldn't really have it, but that's another topic). he can see
> all of the databases on the server. is there any way to make EM only
> show him the two databases which he can access?|||i think i figured out how to do it.
a few changes to master.dbo.sp_MSdbuseraccess
Uri Dimant wrote:
> ch
> Unfortunatly,NO
> "ch" <ch@.dontemailme.com> wrote in message
> news:41862283.D2817F00@.dontemailme.com...
> > i've got a user that has permissions to read and write in two
> > databases. that user has enterprise manager installed and uses it (i
> > know he shouldn't really have it, but that's another topic). he can see
> > all of the databases on the server. is there any way to make EM only
> > show him the two databases which he can access?|||Which means you no longer have a supported SQL server installation. Be careful when modifying system
objects. Not supported.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ch" <ch@.dontemailme.com> wrote in message news:41862EC4.7EF0C91A@.dontemailme.com...
> i think i figured out how to do it.
> a few changes to master.dbo.sp_MSdbuseraccess
>|||ch
You can hide a system databases from seeing them with EM , but user
databases you cannot.
"ch" <ch@.dontemailme.com> wrote in message
news:41862EC4.7EF0C91A@.dontemailme.com...
> i think i figured out how to do it.
> a few changes to master.dbo.sp_MSdbuseraccess
>
> Uri Dimant wrote:
> >
> > ch
> > Unfortunatly,NO
> >
> > "ch" <ch@.dontemailme.com> wrote in message
> > news:41862283.D2817F00@.dontemailme.com...
> > > i've got a user that has permissions to read and write in two
> > > databases. that user has enterprise manager installed and uses it (i
> > > know he shouldn't really have it, but that's another topic). he can
see
> > > all of the databases on the server. is there any way to make EM only
> > > show him the two databases which he can access?|||this is sort of goofy.
query analyzer uses master.dbo.sp_MShasdbaccess intead of
master.dbo.sp_MSdbuseraccess.
sp_MShasdbaccess only returns the databases that the user can get into
or the db's that have a guest account.
sp_MSdbuseraccess returns all databases (when run from master).
query analyzer therefore only shows the user the databases that user can
actually get into which is what i'd really like enterprise manager to
do. i wonder why the two different standards between the two tools?
ch wrote:
> i think i figured out how to do it.
> a few changes to master.dbo.sp_MSdbuseraccess
> Uri Dimant wrote:
> >
> > ch
> > Unfortunatly,NO
> >
> > "ch" <ch@.dontemailme.com> wrote in message
> > news:41862283.D2817F00@.dontemailme.com...
> > > i've got a user that has permissions to read and write in two
> > > databases. that user has enterprise manager installed and uses it (i
> > > know he shouldn't really have it, but that's another topic). he can see
> > > all of the databases on the server. is there any way to make EM only
> > > show him the two databases which he can access?

Wednesday, March 7, 2012

DB name changes daily

Hi,
I am trying to write SQL automation that runs SQL scripts against the daily drop of the database. Each day, a new DB is created using the format (Testdb + xxxxx )where xxxxx= computed build number. Thus today's db name might be TEST12345 and tomorrow wo
uld be Test12346. I have a script that creates the dbname such as Test12345 and when I run it, I get the expected result, but when I try this statement
Use @.dbname
I get an error.
Is there a way to introduce a variable with a Use statement so that I can automatically open the latest db?
Thanks
Hi,
'USE' statement will change the DB context for the current connection and
then go back to where it was before (Default datbase context).
Doing this in an exec will change the context until the exec is completed
and then go back to default database context.
This is small example to show how to do it. This example uses the Northwind
database.
This database has a stored procedure 'emp_list' . From the master database
and execute the following:-
set quoted_identifier off
declare @.dbname varchar(15), @.procname varchar(25)
declare @.startdate varchar(10) , @.enddate varchar(10)
set @.dbname = 'northwind'
set @.procname = '[emp_list]'
exec ('USE ' + @.dbname + ' execute ' + @.procname )
the last statement translates to:
exec ( USE northwind execute [emp_list])
But after the execution again the context will go to the default database.
Note:
The best option rather than using the above is:- (SP_DEFAULTDB)
1. Have a common login
2. Every time after creating the new database use the sp_defaultdb procedure
to change the default db of the login
3. After this when ever that user logins the database context will be the
new database and there is nolt required to give USE XXXXX
Thanks
Hari
MCDBA
"Tomas" <anonymous@.discussions.microsoft.com> wrote in message
news:F9E1B6D0-5378-45AD-8A2C-6DF194B86B0A@.microsoft.com...
> Hi,
> I am trying to write SQL automation that runs SQL scripts against the
daily drop of the database. Each day, a new DB is created using the format
(Testdb + xxxxx )where xxxxx= computed build number. Thus today's db name
might be TEST12345 and tomorrow would be Test12346. I have a script that
creates the dbname such as Test12345 and when I run it, I get the expected
result, but when I try this statement
> Use @.dbname
> I get an error.
> Is there a way to introduce a variable with a Use statement so that I can
automatically open the latest db?
> Thanks

Saturday, February 25, 2012

DB Maintenance Plan not backing up 2 databases..

Snip from Log Output:
[4] Database DYNAMICS: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\DYNAMICS\DYNAMICS_db_200506151939 .BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[6] Database HCB: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HCB\HCB_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 7 secs **
I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
to create subfolders. If I delete the HCB and HCBLLC folders, it does
re-create them. I currently have the SQL Agent running from a domain level
admin account (temporarily for testing) to rule out any possible rights
issues.
I'm stumped.. any Help would be appreciated..
Matt
Is there anything in the SQL errorlog or NT Event log (normally
Application log) that corresponds with the DB maint plan execution times
that may shed some light on the problem? Is E: a mapped network drive
or a local volume? Have you tried creating a new maint plan for one of
the problem DBs on its own?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Matt Williamson wrote:

>I have a DB Maintenance plan that runs and indicates success and shows
>nothing in the log, but doesn't ever write the backup file to disk. This is
>happening for 2 out of 3 databases that are backed up in this plan. All
>databases are set to Full recovery mode and I can back all of them up
>manually without a problem. I also use BackupExec with the SQL agent and it
>works fine. I've been searching the archives looking for anything along
>these lines, but I haven't found anything yet. Here is some additional
>environment info in case it makes any difference.
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
>Windows NT 5.2 (Build 3790

>Snip from Log Output:
>
>[4] Database DYNAMICS: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\DYNAMICS\DYNAMICS_db_20050615193 9.BAK]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>[5] Database HBLLC: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\HBLLC\HBLLC_db_200506151939.BA K]
> ** Execution Time: 0 hrs, 0 mins, 3 secs **
>[6] Database HCB: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\HCB\HCB_db_200506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 7 secs **
>
>I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
>to create subfolders. If I delete the HCB and HCBLLC folders, it does
>re-create them. I currently have the SQL Agent running from a domain level
>admin account (temporarily for testing) to rule out any possible rights
>issues.
>I'm stumped.. any Help would be appreciated..
>Matt
>
>

DB Maintenance Plan not backing up 2 databases..

Snip from Log Output:
[4] Database DYNAMICS: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\DYNAMICS\DYNAMICS_db_20
0506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_20050615
1939.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[6] Database HCB: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HCB\HCB_db_200506151939
.BAK]
** Execution Time: 0 hrs, 0 mins, 7 secs **
I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
to create subfolders. If I delete the HCB and HCBLLC folders, it does
re-create them. I currently have the SQL Agent running from a domain level
admin account (temporarily for testing) to rule out any possible rights
issues.
I'm stumped.. any Help would be appreciated..
MattIs there anything in the SQL errorlog or NT Event log (normally
Application log) that corresponds with the DB maint plan execution times
that may shed some light on the problem? Is E: a mapped network drive
or a local volume? Have you tried creating a new maint plan for one of
the problem DBs on its own?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Matt Williamson wrote:

>I have a DB Maintenance plan that runs and indicates success and shows
>nothing in the log, but doesn't ever write the backup file to disk. This is
>happening for 2 out of 3 databases that are backed up in this plan. All
>databases are set to Full recovery mode and I can back all of them up
>manually without a problem. I also use BackupExec with the SQL agent and it
>works fine. I've been searching the archives looking for anything along
>these lines, but I haven't found anything yet. Here is some additional
>environment info in case it makes any difference.
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
>Windows NT 5.2 (Build 3790

>Snip from Log Output:
>
>[4] Database DYNAMICS: Database Backup...
> Destination: [E:\SQL Backups\Great
> Plains\Databases\DYNAMICS\DYNAMICS_db_20
0506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>[5] Database HBLLC: Database Backup...
> Destination: [E:\SQL Backups\Great
> Plains\Databases\HBLLC\HBLLC_db_20050615
1939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 3 secs **
>[6] Database HCB: Database Backup...
> Destination: [E:\SQL Backups\Great
> Plains\Databases\HCB\HCB_db_200506151939
.BAK]
> ** Execution Time: 0 hrs, 0 mins, 7 secs **
>
>I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
>to create subfolders. If I delete the HCB and HCBLLC folders, it does
>re-create them. I currently have the SQL Agent running from a domain level
>admin account (temporarily for testing) to rule out any possible rights
>issues.
>I'm stumped.. any Help would be appreciated..
>Matt
>
>

DB Maintenance Plan not backing up 2 databases..

I have a DB Maintenance plan that runs and indicates success and shows
nothing in the log, but doesn't ever write the backup file to disk. This is
happening for 2 out of 3 databases that are backed up in this plan. All
databases are set to Full recovery mode and I can back all of them up
manually without a problem. I also use BackupExec with the SQL agent and it
works fine. I've been searching the archives looking for anything along
these lines, but I haven't found anything yet. Here is some additional
environment info in case it makes any difference.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
Windows NT 5.2 (Build 3790:)
Snip from Log Output:
[4] Database DYNAMICS: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\DYNAMICS\DYNAMICS_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[6] Database HCB: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HCB\HCB_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 7 secs **
I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
to create subfolders. If I delete the HCB and HCBLLC folders, it does
re-create them. I currently have the SQL Agent running from a domain level
admin account (temporarily for testing) to rule out any possible rights
issues.
I'm stumped.. any Help would be appreciated..
MattThis is a multi-part message in MIME format.
--080206070603060002020104
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is there anything in the SQL errorlog or NT Event log (normally
Application log) that corresponds with the DB maint plan execution times
that may shed some light on the problem? Is E: a mapped network drive
or a local volume? Have you tried creating a new maint plan for one of
the problem DBs on its own?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Matt Williamson wrote:
>I have a DB Maintenance plan that runs and indicates success and shows
>nothing in the log, but doesn't ever write the backup file to disk. This is
>happening for 2 out of 3 databases that are backed up in this plan. All
>databases are set to Full recovery mode and I can back all of them up
>manually without a problem. I also use BackupExec with the SQL agent and it
>works fine. I've been searching the archives looking for anything along
>these lines, but I haven't found anything yet. Here is some additional
>environment info in case it makes any difference.
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
>Windows NT 5.2 (Build 3790:)
>Snip from Log Output:
>
>[4] Database DYNAMICS: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\DYNAMICS\DYNAMICS_db_200506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>[5] Database HBLLC: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\HBLLC\HBLLC_db_200506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 3 secs **
>[6] Database HCB: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\HCB\HCB_db_200506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 7 secs **
>
>I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
>to create subfolders. If I delete the HCB and HCBLLC folders, it does
>re-create them. I currently have the SQL Agent running from a domain level
>admin account (temporarily for testing) to rule out any possible rights
>issues.
>I'm stumped.. any Help would be appreciated..
>Matt
>
>
--080206070603060002020104
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Is there anything in the SQL errorlog or NT Event log (normally
Application log) that corresponds with the DB maint plan execution
times that may shed some light on the problem? Is E: a mapped network
drive or a local volume? Have you tried creating a new maint plan for
one of the problem DBs on its own?</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Matt Williamson wrote:
<blockquote cite="miduIb6VfgcFHA.616@.TK2MSFTNGP12.phx.gbl" type="cite">
<pre wrap="">I have a DB Maintenance plan that runs and indicates success and shows
nothing in the log, but doesn't ever write the backup file to disk. This is
happening for 2 out of 3 databases that are backed up in this plan. All
databases are set to Full recovery mode and I can back all of them up
manually without a problem. I also use BackupExec with the SQL agent and it
works fine. I've been searching the archives looking for anything along
these lines, but I haven't found anything yet. Here is some additional
environment info in case it makes any difference.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
Windows NT 5.2 (Build 3790:)
Snip from Log Output:
[4] Database DYNAMICS: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\DYNAMICS\DYNAMICS_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[6] Database HCB: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HCB\HCB_db_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 7 secs **
I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
to create subfolders. If I delete the HCB and HCBLLC folders, it does
re-create them. I currently have the SQL Agent running from a domain level
admin account (temporarily for testing) to rule out any possible rights
issues.
I'm stumped.. any Help would be appreciated..
Matt
</pre>
</blockquote>
</body>
</html>
--080206070603060002020104--

Thursday, March 29, 2012

DB2 Write Image to Blob field

Wednesday, March 21, 2012

db rights

db rights

Monday, March 19, 2012

db rights

DB restore puzzle

Sunday, March 11, 2012

DB Recovery Model Type through SQL

DB Recovery Model Type through SQL

db permissions in EM

db permissions in EM

db permissions in EM

Wednesday, March 7, 2012

DB name changes daily

Saturday, February 25, 2012

DB Maintenance Plan not backing up 2 databases..

DB Maintenance Plan not backing up 2 databases..

DB Maintenance Plan not backing up 2 databases..

DBCC CHECKDB

Blog Archive

About Me