Viewing 15 posts - 931 through 945 (of 1,097 total)
Well in fact yes. You could create more data files with new filegroups for the tables that you want to backup, and then backup the filegroup
February 11, 2003 at 2:07 pm
you can use "sqlservr -T1204 -T257"
February 11, 2003 at 12:16 pm
I think the problem is that when the DTS package runs within a job is does with the security context of the SQL Server Agent Logon account. You should use...
February 11, 2003 at 10:48 am
Strange...the antivirus is in the same box as the sql server?. If so, try to start the sql agent with the antivirus disabled.
February 10, 2003 at 1:57 pm
I would use replication store procedures and mcall them to avoid overhead in the updates. Also could create severals publication with different articles, and schedule the replication to avoid concurrent...
February 10, 2003 at 1:44 pm
If your non systems databases are not part of a replication then you want have any problems.
But you can't do that with your systems db.
I would copy only the user...
February 10, 2003 at 1:23 pm
To extract it from tape restore the log from the tape with T-sql commands.
February 10, 2003 at 1:05 pm
Any errors in the SQL Agent Log. Try running a trace while you are creating the trigger.
The index that you create was on a published table???
February 10, 2003 at 12:51 pm
Is seems that the problem is on the T-sql inside the plan. Check what the plan does and check any difference with other target server. If you are acceding the...
February 10, 2003 at 12:44 pm
Is seems like an win 2000 login problem. Why don't you create another user in your server with admin rights and use that login for your services. Try rebooting the...
February 10, 2003 at 9:51 am
Did you try :
Backup Log LogName with Truncate_Only
This flushes all the commited transactions to the data files, and release some space from the log. After this you should backup...
February 10, 2003 at 8:37 am
From what you said I think that you restore the full with norecovery and tried to restore the differential with recovery.
You shouldn't have any error. Can you post the t-sql...
February 7, 2003 at 2:51 pm
We have once server wich replcates to other 74 servers, and also they all replicate to the master server. We use transactional replication and never had big problems. But i...
February 7, 2003 at 1:31 pm
Wich tape options are you giving to the Backup statement?
February 6, 2003 at 7:33 am
You could create a job to be run every day to check for the condition, or if inserts, updates or deletes are common in the db, create a trigger to...
February 6, 2003 at 6:45 am
Viewing 15 posts - 931 through 945 (of 1,097 total)