Viewing 15 posts - 151 through 165 (of 219 total)
Make sure you are not in that database in the QA
Shas3
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
Shas3
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...
Shas3
June 27, 2003 at 3:51 pm
Yes both are same; Incremental is nothing but the Differential backup
Shas3
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...
Shas3
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?
Shas3
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...
Shas3
June 27, 2003 at 1:45 pm
Here is an Article By Joseph Sack on Trapping DTS Errors
http://www.joesack.com/DTSErrorTrap.htm
Shas3
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...
Shas3
June 27, 2003 at 10:13 am
Here is a good Article form Brian
http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp
Shas3
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
Shas3
June 26, 2003 at 3:11 pm
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
Shas3
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...
Shas3
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...
Shas3
June 26, 2003 at 2:32 pm
Viewing 15 posts - 151 through 165 (of 219 total)