473,836 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using SQL Server 7.0, Backup maintenance plan not working

I am using SQL server 7.0. After restoring all the databses (Except
distribution) Everything seems to be working fine except the backup
maintenance plan. I put following detail in the maintenance plan

"General Tab:

Plan Name --- DB Maintenance Plan1
() All Databases

Optimizations tab:

Reorganize Data and Index Page
Change free space per page percentage to 10%

Remove unused space from database files

Shrink Database when it grows beyond 50 MB
Amount of free space to remain after shrink 10% of the data space
Schedule: Occurs every 1 week(s) on Thursday, at 1:30:00 PM.

Integrity tab:

Chack database integrity
Include indexes.
Attempt to repair any minor problem
Schedule : Occurs every 1 week(s) on Thursday, at 1:00:00 PM.

Complete Backup tab:

Backup the database as part of the maintenance plan
Verify the integrity of the backup upon completion
Disk use this directory: d:\SQL Backups
Backup file extension: BAK
Schedule: Occurs every 1 day(s), at 2:10:00 PM.

Transaction Log Backup tab:

schedule: Occurs every 1 day(s), at 2:00:00 PM.

Reporting tab:

Write report a text file in Directory: D:\SQL Backups\LOG "

Problem:
My databases(mrodu ction as well as systems) sre not at all getting
backed up according to above plan.
Error Message in the Log Directory:
"Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO
(ODBC SQLState: 42000)] Error 4062: [Microsoft][ODBC SQL Server
Driver][SQL Server]Cannot open user default database '<ID>'. Using
master database instead."

In the SQL server registration properties the login through which
getting logged into the EM for that, default database is "my production
database".

Is this problem because of the distribution db which I am not able to
restore.

Please help

Deepak Sinha

Aug 21 '06 #1
1 3639
microsoft . public . sqlserver (dp*******@gmai l.com) writes:
I am using SQL server 7.0. After restoring all the databses (Except
distribution) Everything seems to be working fine except the backup
maintenance plan. I put following detail in the maintenance plan
...
Problem:
My databases(mrodu ction as well as systems) sre not at all getting
backed up according to above plan.
Error Message in the Log Directory:
"Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO
(ODBC SQLState: 42000)] Error 4062: [Microsoft][ODBC SQL Server
Driver][SQL Server]Cannot open user default database '<ID>'. Using
master database instead."

In the SQL server registration properties the login through which
getting logged into the EM for that, default database is "my production
database".

Is this problem because of the distribution db which I am not able to
restore.
It's unclear what you restored from, but if the databases originates on
a different server, you typically have a matching problem between database
users and logins. The default for this login may be a database that exists,
but he may not be valid user of that database.

Running sp_helpuser in the database in question can show if you have
this problem. If username and logins are just randomly correlated,
then you need to remap with sp_change_users _login. See Books Online
for details.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 21 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2001
by: jwbeaty | last post by:
Here's a weird one. I'm running SQL Server 7 and when I run a backup something weird happens. When I perform the backup via Enterprise Manager by right clicking on the database I want to backup, I click on OK but no progress blocks show up in the window showing you the status of the backup. The completion window pops up saying that the DB has been backed up. OK--Fine, maybe the backup is really quick. Then, through Explorer, I look...
1
1822
by: cloverme | last post by:
The database is configured for single publisher, many subscribers, merge replication. The maintenance plan started to fail a couple of months ago and the database would not get backed up. After clearing all the locks, I am able to backup the database manually. The locks return again and I'm not able to backup the database with the maintenance plan. How can I get around the lock issue or solve it so that I can backup the database again?...
2
1982
by: Tam | last post by:
Hi, I am new to Win2k and SQL server and need to back up everything each night. I used the supplied NT backup utility to schedule a backup but this missed some files that were open or in use. I am more used to Unix/Informix where I could backup everything whether it was in use or not. How or what would you recommend I use to do my backups? Thanks.
1
1484
by: eddie wang | last post by:
Hello, I am running SQl Server 7.0. I have a database maintenance plan that runs once a day to perform backups. It seemed that the database backup files were created successfully. The problem is that if i go to "SQL Server Agent" --> "Jobs", the status of the backup job always shows "Executing" (even after 1 day). I tried "Refresh" and it didn't work. The database log and windows log also didn't help me to troubleshoot. The database is...
9
9952
by: tech_guru | last post by:
Hello!! I am relatively new to SQL and am having a problem. I have taken over a SQL 2000 db that did not have any backup plans scheduled for it. I created a maintenance plan that backs up the database every night and another plan that backs up the system databases once a week. I ran both these jobs successfully, but when I created a third plan to backup the transaction log it fails with the following message: Executed as user: NT...
0
2259
by: bohuge | last post by:
Hey! At the time being I'm working on a backup solution for a Qtek9090 pocketpc, which should be able to find and backup outlook data to a server, local files, messages and contact from the sim card (and backup them to a server as well) all written in C#. So I'm making a wrapper for the sim manager api. In order to use it's functions in my device application, I've used platform invoke method, to acces the simmanager functions from...
0
1463
by: pk | last post by:
I have a problem that I would like to resolve through scripting, but I'm not sure how to go about it (or if it's even possible.) We're trying to work around a bug ( http://support.microsoft.com/default.aspx?scid=kb;en-us;303292&Product=sql2k ) that requires us to split up our maintenance plan into two parts. In the first, we backup "All User Databases". This runs fine. The second maintenance plan backs up the transaction logs and then...
4
3696
by: fniles | last post by:
I have created a backup maintenance plan in SQL Server 2005. Is there any way to run/execute this SQL Server backup maintenance plan from VB.NET ? Thank you.
2
1728
by: robboll | last post by:
Maybe I am asking for the world, but it seems to me that I should be able to run some scripts against a SQL Server to derive everything of interest to a database administrator. Things like: Server Name Database Name Database Owner (DBO) File Group(s) Users and Permissions Database Size/Log File Size and Space Available
0
10823
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10577
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10243
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9359
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7775
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6975
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5642
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4443
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4003
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.