Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2009-01-09 : 08:45:32
|
| I have a SQL 2005 server which was built from scratch. The databases on this machine were restored from a SQL 2000 server and the server was decommissioned. I also see under Legacy that there are DTS packages from the previous server. I don’t remember if I have copied them or how they have been transferred. (An application vendor was helping us at the time they wanted to install their new application and migrate from SQL 2000 to SQL 2005.)However, there is a weird thing happening on this new machine. I created a maintenance plan for backups to start every day at 8:30 pm. I’ve noticed that I have two sets of backups. One happens at 6:30 pm and the other happens at 8:30 pm. There used to be a backup maintenance plan on the previous server to backup at 6:30 pm. I dropped my backup maintenance plan and the 8:30 backups were stopped but still the 6:30 ones are being generated. There is an optimization maintenance plan but there is no backup request inside it. There is no job for backup on SQL Server, too. There is no Windows Schedule Task either. I checked the Services and there is no other SQL Server instance running on the machine. The following services are running:SQL Server (MSSQLSERVER)SQL Server Agent (MSSQLSERVER)SQL Server BrowserSQL Server FullText Search (MSSQLSERVER)SQL Server Integration ServicesSQL Server VSS WriterA sample of what is in SQL log:Date 1/9/2009 6:27:09 AMLog SQL Server (Current - 1/9/2009 6:27:00 AM)Source BackupMessageDatabase backed up. Database: MyDatabase, creation date(time): 2008/05/07(10:52:51), pages dumped: 292179, first LSN: 55862:3741:186, last LSN: 55862:3818:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {' MyDatabase_00__bee3d40f_798b_4dff_a927_bbf3b3e76200_'}). This is an informational message only. No user action is required.Where else should I check? How these backups are being generated?Canada DBA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 10:08:02
|
| Does Maintenance plan exist in Legacy Folder.See this if it helps.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114 |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2009-01-09 : 10:16:24
|
| Found the issue: A while ago, right after we created our prod server, I was supposed to create a Dev server. Since I used to copy and paste physical SQL files technique in SQL 2000 to recreate another machine. I tried the same here with SQL 2005 and created the Dev server by copying exact folders to the new server. Today, after I checked everything on the prod, a friend warned me about a job on another machine pointing to this server. I started with one of our Dev server and there was a maintenance plan and a job. Both had same name and looked the job belongs to the maintenance plan. There was no BAK file under E:\backups but SQL Agent job folder shows the job runs every night. I ran the job and noticed the backups were created in prod machine. Dropped the maintenance plan on the Dev but still the job was there!! And I couldn’t drop the job because of an error in msdb. Well, it seems copy and paste technique does not apply to SQL 2005 or at least it is not that simple. I have to rebuild the dev machine. Thanks God I didn’t create our DR or another prod by using this technique!!!Canada DBA |
|
|
|
|
|
|
|
|
Is there a hidden job?