Viewing 15 posts - 76 through 90 (of 139 total)
Are you sure you are on SQL Server 2000 because as per my knowledge SQL Server Agent Proxy Accounts are new to SQL Server 2005.
Just check.
August 23, 2009 at 8:52 am
You can download the guide from here also. 🙂
August 23, 2009 at 8:37 am
All you need is C2 Administrator’s and User’s Security Guide Revision 1.1
you can donwload this guide from :
August 23, 2009 at 8:36 am
Hi David,
I don't know why you are using the same SQL Box to design the DTS Packages.
You can try this, Install SQL Server Client tools on some other test server,...
August 23, 2009 at 7:42 am
I'll recommend to use the below script
[Code]select 'tablediff -sourceserver .\sql2k5 -sourcedatabase test12king -sourcetable '
+ TABLE_NAME
+ ' -destinationserver . -destinationdatabase test12king -destinationtable '
...
August 23, 2009 at 6:09 am
If you're testing this on the same server then its Ok
otherwise you need to backup and restore the Service Master key also.
August 23, 2009 at 5:33 am
You can take the backup of
Master key as well as the Certificate with the below mentioned scripts:
From the Instance which you've restored from your backup
backup master key to file...
August 23, 2009 at 5:29 am
The problem is with the backup set, either it is not available or your ID is not authorized to use that.
In place you can copy the backup to a local...
August 17, 2009 at 3:40 am
Also another optin is Database Snapshot which is introduced in SQL Server 2005 onwards.
What solution you are talking abt with DB Snapshot?
August 17, 2009 at 2:48 am
Pls. run getdate() and then check this time with the logs its generating.
Both the times should be same. (there can be a small diff. but that much diff. is not...
August 17, 2009 at 1:31 am
1. Backup job runs every 1 hrs
2.Delete files older than 72 hrs
3.Alert if no backup occurs with in 2 hrs
4.Copy job runs every 1hrs
5.Delete files older than 72 hrs
6.Restore job...
August 17, 2009 at 12:07 am
"Snapshot replication has a lower continuous overhead on the Publisher than transactional replication, because incremental changes are not tracked. "
In Snapshot replication it creates a snapshot at once and apply...
August 16, 2009 at 9:46 pm
I think i am out of sync.
As far as i know, Its not possible to intall SQL Server Agent only, And if you are installing SQL Server it comes with...
August 16, 2009 at 9:21 pm
Viewing 15 posts - 76 through 90 (of 139 total)