Recent content by Apollo21

We utilize Control-M to schedule all of our production jobs. I would like to include the SQL Server Maintenance Plan Jobs within that product. I do it now with MSDE and I would like to implement with SQL Server 2000 & 2005. I imagine there are different ways of accomplishing this. Does anyone...

I am having the same issue today. We use it sparsley, no telling when it really started. Any help would be a welcome addition to the day.

Good Day Everyone. The only constant is change. We have a mixed environment of SQL Server MSDE, SQL Server 2000 Standard w/processor and server license set ups. We would like to simplify this mix because other people and applications are about to get involved. Also we are thinking that it is...

Can anyone tell me if you can add more than one install of SQL Server [either 2000 or 2005 standard] to the same server without one of them being a named instance of the other. [I know all about named instances and love the concept, but I have a stakeholder client that has a few of these...

Will the management studio be able to conduct scheduled automated backups of databases in 2005 express? I have just gotten this request out of the blue. I need to know the answer and do not have the time to download all the free peices and find out. Can anyone help me? Thank you in advance. [I...

Denny, Just to clarify, the table was there but the contents were supposed to have populated the table did not come along. Someone forgot to populate the table. Thank both of you for your answers. Apollo21

Ok, I know the answer to this must be simple, but I can not find it in the documentation. I am running SQL Server 2000 Standard Edition on a Windows 2003 Server. I have restored a backup from another server and all is well. There happened to be a table that did not make it in the initial backup...

Ok, Thanks for the response. I ran the report and I got a result like this; dbo 0xE1BDA9674BD4E44385DFFF509DE57C8C Does this mean I have to link the dbo to a user account under this new database?

Good Day! SQL Server 2000 SP4 running on Windows OS 2003: I have recently restored a database from server A to server B under a new Name of Database1. After the restore I attempted to add the 'sa' login to Database1 as a user. The system will not let me. It gives the following message; 'Can...

Could the primary be making the secondary disk not to be seen. Because right now I have both of them in there and BIOS is not seeing either one. I will not be home until 5:00 P.M. this evening, so I can't try anything right away. Do you have any other ideas? Thank you for responding as you...

Yes, It was ABS and the Drive is a Westren Digital 74 Gig Raptor that had been working fine up to about 2 months ago. I was getting blue screens every once in a while. I thought putting down a new copy of the OS (XP SP2) would aleviate the problem, but it only made it worse, to the point where...

I have a desktop computer w/Two SCSI drives. The secondary drive went bad about a week ago and I now have its replacement in my hand. During that week that it was on its way( Seagate), I had a reoccurring blue Screen episode that would not stop. Most times I could not boot the thing into...

By the way my file name starts off with todays date like '20080831 Test Differential Bkups.bak'

Hi Denny, thank for giving this a try. Let me try to explain. If I am only changing the file name once a day (automatically), then I have them going into the same device for that day. That is ok, but I want to know if there is a way for me to limit the number of those daily file devices. If...

I am currently backing up a series of databases utilizing full backups, log backups and differential backups. I have used the maintenance plans to create the full and log backups. With the differentials I created a job with the following code. BACKUP DATABASE XXX TO DISK=@filename...