Viewing 15 posts - 331 through 345 (of 463 total)
Regarding your questions, i can't think of anything else except just verify all the settings which you have provided above and make sure that there is not any other process eating...
July 7, 2004 at 10:24 am
Unfortunately, none of the system tables stores the login information. As steve mentioned, you need to turn the logging on.
July 2, 2004 at 9:48 am
Jim,
My apologies. I don't know if it was a cached session or something wrong with me that when i saw the thread, it was still in the initial steps where...
July 1, 2004 at 9:00 am
You can create the logins on the new server and then run the procedure sp_change_users_login which would map the user id's to logins.
July 1, 2004 at 8:53 am
A mapped drive is only available to the user who creates it. SQL Server runs under the system account and the mapping is not recognised by the system account(unless it...
June 30, 2004 at 6:47 pm
Are you referring to cross database ownership ? That's something you can turn on and off with sp_dboption
June 30, 2004 at 6:41 pm
I agree with all that backing up to a network drive is not a good idea.
But if you still need to back up, try giving a UNC path and hope...
June 30, 2004 at 10:01 am
SP3a read-me file says.
To revert to the pre-SP3a versions of SQL Server 2000 components, you must have back ups of the master, msdb, and model databases taken prior to installing SP3a
"one...
June 30, 2004 at 9:59 am
Try changing the owner of the object to dbo
sp_changeobjectowner 'prco_name','dbo'
June 30, 2004 at 9:55 am
How big is the database that fails the backup? (Could be timing out)
The database is only 600 MB big.
Are all the databases backing up at the same time or...
June 29, 2004 at 12:38 pm
Thanks for the feedback. Do you mean network issues with the network drive ? Also, we have 5 more user databases which are not having any issues to be backed...
June 29, 2004 at 10:53 am
We have canned application in our environment and unfortunately you have to stay with them.
Regarding security, we have a separate id which requires...
June 29, 2004 at 10:50 am
I think SQL Profiler should be a good place to start. You can just start a standard trace and direct the output to a table. Make sure that you have...
June 29, 2004 at 10:17 am
Viewing 15 posts - 331 through 345 (of 463 total)