Viewing 15 posts - 2,866 through 2,880 (of 2,893 total)
How frequently do you need to refresh the data ??
I use transactional & snapshot replication to get subsets of production databases to other databases. Then users can query the subsets...
February 1, 2005 at 9:13 pm
What does it show under "Next Run Date" ??
Sometimes I've had the job enabled, but the schedule was not enabled. They both must be enabled.
Perhaps there's an "end date" in...
February 1, 2005 at 9:08 pm
If you backup the database on the "old" server, then do a restore on the "new" server, it will create the database as part of the restore. You might want...
February 1, 2005 at 8:30 pm
I had to do something similar a while ago. I think I did something along the lines of:
- Script out the steps to delete the publication and save it.
-...
December 15, 2004 at 9:52 am
You can use "snapshot" replication instead of "transactional" replication for tables that don't have a primary key. This will replace the table each time instead of just sending changes, so...
November 21, 2004 at 12:40 am
You want to set up replication on other servers (B & C) that's the same as what you have now (server A)?
If you just want to copy the publication, you can...
April 7, 2004 at 8:17 am
What about making objects DBO owner to start with, such as tables and stored procs ?
Does a user have to be a System Administrator in order for their...
January 5, 2004 at 9:19 am
Does a user have to be a System Administrator in order for their objects to automatically be DBO owner ?
January 5, 2004 at 9:13 am
Not sure, but how about using sp_droppullsubscription first to get rid of the orphan subscription, then maybe you can drop the publication ? (Either through EM or manually via...
December 24, 2003 at 10:41 am
I go into EM, make all the changes, choose "Save change script" to capture all the commands, then exit without saving the actual changes.
Or sometimes I do save the actual...
December 12, 2003 at 8:44 am
The job itself is enabled, but how about the schedule entry ? Right click the job >> Properties >> Schedules >> Edit ......... Is the enabled...
December 9, 2003 at 12:46 pm
I did this recently .......
I just used Enterprise Manager to generate a SQL script for all SPs, but put them all to one file big on your C drive, then...
December 8, 2003 at 9:22 am
Use SIMPLE if going back to the last FULL backup is good enough (usually used in test or light usage environments).
Use FULL if you want the security of...
November 24, 2003 at 10:15 am
Similarly to others here, I back up to another drive, deleting the previous day's backup. After the backup, the network backup copies my backup to tape. I also backup...
November 24, 2003 at 10:07 am
You should be able to add it through Enterprise Manager ...... That's how I do it.
November 17, 2003 at 1:40 pm
Viewing 15 posts - 2,866 through 2,880 (of 2,893 total)