Viewing 15 posts - 151 through 165 (of 219 total)
Make sure you are not in that database in the QA
July 1, 2003 at 8:49 am
Two reasons, the job may be doing the rollback or your job retry attempts set a non – zero value
June 30, 2003 at 1:13 pm
Yes you are right, If it is SQL Authenticated then you don't need the Domain name. What is your Security mode configured on the other box? Just make sure its...
June 27, 2003 at 3:51 pm
Yes both are same; Incremental is nothing but the Differential backup
June 27, 2003 at 3:32 pm
While restoring the backup you need to change the Drive letters. Go to the EM-> Databases->Resotre Database ->From Device -> Choose the backup File -> and specify the database name->Go...
June 27, 2003 at 3:21 pm
How are you connecting to the other server? Make sure you qualify the user with domain name\username. Also what is the security mode on the other server?
June 27, 2003 at 3:04 pm
By default msdb set to simple recovery model, since we don’t take the log backups for msdb, we don’t need a full recovery model. Simple database recovery is nothing but...
June 27, 2003 at 1:45 pm
Here is an Article By Joseph Sack on Trapping DTS Errors
June 27, 2003 at 12:00 pm
Executive is nothing but SQLServerAgent. If you are using distributed transactions (Calling the remote stored procs on some other SQL Server and Distributed updates) in your application you might want...
June 27, 2003 at 10:13 am
Here is a good Article form Brian
http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp
June 27, 2003 at 8:36 am
I guess you will have the option to check box to synchronize the data immediately or some thing like that while configuring the Rep
June 26, 2003 at 3:11 pm
Very good Article on Moveing DTS Pack
June 26, 2003 at 2:53 pm
Go to http://www.Google.com and search for SQL DTS. Here is a very good site about the DTS Pack
June 26, 2003 at 2:50 pm
By default public role user can create/ Delete/ Execute the DTS packages. You need to explicitly remove the permissions to block them. Revoke the permissions on sp_add_dtspackage, sp_enum_dts_packages and sp_get_dtspackage...
June 26, 2003 at 2:46 pm
No way you can install with a single click that includes your user database. If you have your DB backup or script as Antares said, install MSSQL and then restore...
June 26, 2003 at 2:32 pm
Viewing 15 posts - 151 through 165 (of 219 total)