Viewing 15 posts - 121 through 135 (of 179 total)
A float type FK? Never seen that before. I'd say you would have more problems with any applications connecting to it then data issues. Just create another...
March 12, 2009 at 5:56 am
select @@servername as 'instance name', count(*) as 'Nº of DBs by Instance', sum(a.size) as 'espaço alocado (mb)', sum(a.used) as 'espaço utilizado (mb)', sum(a.size)-sum(a.used) as 'espaço livre (mb)'
from db_name..tbl_name a, sys.sysdatabases...
March 12, 2009 at 5:48 am
Check your SQL logs and see if it is actually performing a differential or full backup.
For differential backup you would see: "Database differential changes were backed up. Database: "
For...
March 10, 2009 at 8:45 am
From install folder (Default: c:\Program Files\Microsoft SQL Server) \90\Setup Bootstrap\LOG\FilesContains log files. I just do a text search for the instance and look for the file like SQLSetupXXXX_...
March 10, 2009 at 6:48 am
Did you check the link I posted above? I think you need to specify the fire_triggers. Setup your Import/Export job, save to disk (do not run). Open...
March 9, 2009 at 8:48 am
Are you getting error when creating or executing the job? Does your account running SQL agent have access to run/create jobs? (Local System account, or user in a...
March 9, 2009 at 7:02 am
I would start looking down this path
http://msdn.microsoft.com/en-us/library/ms187640(SQL.90).aspx
How are you bulk inserting the data?
March 9, 2009 at 6:58 am
Are you >= SP2? Also, did you try creating the job on the server itself (remote desktop to server) using SSMS (client) on the local sql server?
March 9, 2009 at 6:51 am
As a work around until MS support helps, perhaps restore to other 2005 server then detach/attach to your destination server?
March 9, 2009 at 6:46 am
If you also had the error while doing a straight copy you may have something in your event logs.
also you could check this
http://support.microsoft.com/default.aspx?scid=kb;EN-US;304101
March 4, 2009 at 10:32 am
if your db backup is 250gb, doesn't mean restored it will be 250GB of disk size. Could be trying to allocate more depending on the file sizes before the...
March 4, 2009 at 6:51 am
Look for services that are running that you don't recognize ... or any that are related to backup software/vendors. Are you sure one of you sysadmins didn't install some...
March 4, 2009 at 6:38 am
I havn't run into this issue before so I'm not sure if I can provide any more help.. but the next things I would try is create an entry in...
March 4, 2009 at 6:30 am
Yes, that is incorrect ... pls check http://msdn.microsoft.com/en-us/library/ms345448.aspx
At restore time, before you restore a differential backup, you must restore its base. Then, restore only the most recent differential backup...
March 4, 2009 at 6:23 am
I had an issue like this before so I did a quick search to find what helped me and I realized it was not the same. But I ended...
March 4, 2009 at 6:08 am
Viewing 15 posts - 121 through 135 (of 179 total)