Viewing 15 posts - 1 through 15 (of 58 total)
perhaps permissions issues at the OS level?
October 15, 2008 at 12:35 pm
Are you under a mandate to have to use the DBCopy wizard? If not, why not try the good old tried and true "backup and restore" ?:D
October 15, 2008 at 12:32 pm
look at this.... although this only reads, I'm sure there is a registry method to write to the registry as well. I would take a backup of the registry...
October 15, 2008 at 12:16 pm
Create a batch file that BCP's out the data from the source and BCP's in the data to the destination???
October 15, 2008 at 12:07 pm
this happend to me a few years back... this solved my problem. although we didn't change anything from the sqlserver end, the developement end (.NET) was upgraded.
October 15, 2008 at 7:53 am
Operations performed in bulk either in or out....BCP....BULK INSERT.... SELECT INTO....
October 15, 2008 at 7:42 am
I would check the event log for any errors or warnings related to NIC teaming. If there are any, this may very well be a probable cause.
September 8, 2006 at 6:57 am
run this and let us know the last time your transaction log was backed up.
SELECT B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(),
MAX(Backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,
ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NEVER') as LastBackupDate
FROM master.dbo.sysdatabases...
September 7, 2006 at 7:38 am
You really need to find out if it is a problem or not. We have transaction logs that can under certain conditions grow 1GB / minute.
It may be that large...
September 7, 2006 at 7:26 am
Are your servers configured for NIC Teaming? If so, try breaking them and see what happens. We've had a similar case during restores of large databases 300-400 GB and seeing...
September 7, 2006 at 7:10 am
hmmm. I guess this is a question for folks that like to keep diaries.
The list is endless.... better for you google it up and see... there are quite a few...
September 5, 2006 at 11:20 am
I've seen this happen where there was a linked server query running and killed. However the connection persisted and was reporting it was at a 100 percent in the rollback...
September 5, 2006 at 10:33 am
see this excellent article posted today on this site...
August 30, 2006 at 10:19 am
Give some more info on your server cfg. What edition do you have and amount of RAM. What is your sqlserver build number? 2039?
top 3 links from google....
http://support.microsoft.com/kb/832674
http://support.microsoft.com/?kbid=903002
August 28, 2006 at 2:31 pm
Microsoft has some good articles on this. So does BOL...see the title "Restoring the master Database from a Current Backup"
Below is nice detailed link on a lot of the...
August 28, 2006 at 2:23 pm
Viewing 15 posts - 1 through 15 (of 58 total)