Viewing 15 posts - 2,461 through 2,475 (of 2,636 total)
That message is generated whenever a maintenance plan job fails. Look in 'View job history' in Enterprise Manager and check the steps in the job to see what exactly is failing.
Greg
November 4, 2004 at 10:02 am
I'm sorry to say that there is no way to view or reset the owner password. Perhaps the developer saved a previous version of the package without a password? If...
November 4, 2004 at 9:52 am
What recovery model is used for the destination database(s)?
What are the details of your import? Are you only moving stored procedures? Are you dropping and recreating the objects in the...
November 4, 2004 at 9:41 am
Restore the database backup to a new database then use DTS to replace the tables in the original database. See "How to restore a database with a new name" in...
November 1, 2004 at 3:29 pm
There is role in MSDB called TargetServersRole that allows members to view jobs. It's undocumented and subject to change in future releases and service packs, it works now.
Greg
November 1, 2004 at 9:33 am
Make a backup of the existing database and restore it with a new name. See "How to restore a database with a new name" in Books OnLine.
Greg
November 1, 2004 at 9:23 am
You have to restore a full database backup before restoring a differential.
Restore a full database backup using WITH NORECOVERY i.e.
RESTORE DATABASE mydb FROM mydbbackup_bak WITH NORECOVERY
Then restore the differntial...
October 28, 2004 at 4:10 pm
A user database backup contains all objects in the database including the objects you listed. A backup of the msdb database contains jobs and DTS packages because data about them is...
October 27, 2004 at 12:32 pm
You do need Enterprise edition to do Microsoft log shipping. Here's a link to an article for a home grown log shipping solution that can be implemented on Standard edition.
October 27, 2004 at 12:12 pm
You'll either have to disable the foreign key constraints on the destination tables before loading the data or you'll have to load the data in a specific order i.e. parent...
October 27, 2004 at 12:02 pm
There's another thread about this in the Backups forum: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=142470#bm142884
Greg
October 27, 2004 at 10:51 am
I haven't used DTS to import from AS400, but you should be able to specify the login and password in the AS400 connection in your DTS package.
If you can provide...
October 27, 2004 at 10:45 am
It may be a permissions problem. Scheduled packages run under the security context of the login that starts SQL Server Agent. Check the permissions of that login. It has to...
October 27, 2004 at 10:41 am
I'm making some assumptions about your situation, so please correct me if I'm wrong.
I assume you're using the DTS import/export wizard and that the primary key of your
table is...
October 27, 2004 at 10:21 am
October 27, 2004 at 9:33 am
Viewing 15 posts - 2,461 through 2,475 (of 2,636 total)