By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

Using SQL Server 7.0, Backup maintenance plan not working

P: n/a
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(mroduction 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
Share this Question
Share on Google+
1 Reply


P: n/a
microsoft . public . sqlserver (dp*******@gmail.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(mroduction 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****@sommarskog.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 discussion thread is closed

Replies have been disabled for this discussion.