Viewing 15 posts - 31 through 45 (of 314 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 314 total)