Viewing 15 posts - 31 through 45 (of 315 total)
Is there any advantage implementing ENT Edition againist running the scripts to load the data (TRN Logs/Full Backups)?
I heard somethere about having a monitor for log shipping. Not sure if...
.
March 30, 2004 at 11:37 am
vikramnat: you are lucky.. 🙂
One of my database Log is growing to 20-24GB last few weeks. Initially I thought there must have been some process which caused...
.
January 10, 2004 at 12:51 am
By default SQL Server does not offer this functionality. But we can achieve this thru Triggers, Timestamp colomn or comparision.
.
December 4, 2003 at 4:44 am
I was mistaken. We use this process for two main reasons:
1. If we have to change NULL to NOT NULL
2. For SQL Server 6.5 Boxes.
I overlooked the "ADD" part...
.
November 18, 2003 at 10:31 am
If you have DBArtisan its point and click...
OR
1. You can create table with following :
SELECT *
INTO dbo.TABLE1_Backup
FROMdbo.TABLE1
2. Drop the existing table (TABLE1). Extract access rights on TABLE1 before...
.
November 18, 2003 at 9:50 am
dharper,
Restarting the SQL Server Agent didn't work. Restarting the BOX itself did help earlier. But since we did the Server Upgrade recently, I didn't want to have this reboot during...
.
November 14, 2003 at 8:47 am
Thank You jmaurais. I did not explore this. Thanks Again.
.
November 12, 2003 at 9:32 am
Also do not forget to update statistics after truncating the tables.
.
November 11, 2003 at 10:18 am
If you have admin rights on the BOX, then you could try register with "Windows Authentication" and change the password in EM. Or you can change the password in QA...
.
November 11, 2003 at 10:09 am
Yesterday I tried killing the job from EM, and it went into CANCELLED status & not running now. But this process is still running as "runnable process" status (when run...
.
November 11, 2003 at 10:03 am
Jonathan & vambati: I am taking the backups of all the databases as well as copying the DATA files & LOG files (after stopping the services) to different machine before...
.
November 7, 2003 at 3:51 pm
I would recommend to take a full backup of the database, LOG backup, check if anyone is using the database. If no one is using then, use BACKUP LOG with...
.
November 5, 2003 at 8:17 am
If you are not sure why something is not working on NT/2000, reboot few times. Always works for me. May be its being nice to me.
:-))) Sorry making this funny.
Frankly,...
.
November 4, 2003 at 10:22 pm
No. Cannot do this because we receive this file from the client's system automatically pushed into a seperate folder. This will be picked by my job, process then move to...
.
October 31, 2003 at 11:12 am
oooops.... I did't see tejeshc's response... I was typing by then....
This seems to be a nice idea, except that I am going to have an extra job getting added to...
.
October 31, 2003 at 5:33 am
Viewing 15 posts - 31 through 45 (of 315 total)