Viewing 15 posts - 91 through 105 (of 242 total)
iqtedar (1/4/2009)
ok ..i will ask him to do...so then what would be the default size of the log file...thanks..
It depend on the recovery mode, in simple recovery size is less...
January 5, 2009 at 2:14 am
shiwani2002sg (1/5/2009)
There exist 2 tables
table1
A B C
1 554 dd
1 ...
January 5, 2009 at 2:01 am
DBADave (1/4/2009)
January 5, 2009 at 1:56 am
DonaldW (1/2/2009)
Mad-Dog (1/2/2009)
SQL 2005.yes i'm seeing that my tempdb database sometimes grow for 40-50GB.
even if i wait few hours and try to shrink the tempdb data file i can't.
There's a...
January 2, 2009 at 5:48 am
Mad-Dog (1/2/2009)
SQL 2005.yes i'm seeing that my tempdb database sometimes grow for 40-50GB.
even if i wait few hours and try to shrink the tempdb data file i can't.
I advice to...
January 2, 2009 at 4:50 am
GilaMonster (1/2/2009)
Mad-Dog (1/2/2009)
January 2, 2009 at 2:45 am
PaulB (1/2/2009)
WayneS (1/1/2009)The differential backups are taking about 1-2 seconds, even at the end of the day. This way, I would only need to restore, at most, from 2 backup...
January 2, 2009 at 2:43 am
sandhyarao49 (1/1/2009)
Can any one tell me where and how to check DB statistics status on a particular server.
And is there any way to see that it was last updated...
January 1, 2009 at 10:38 pm
Nicholas Cain (1/1/2009)
The -r option will allow you to put files and folders recursively.
Or create a batch file using activex with all your ftp commands...
January 1, 2009 at 10:35 pm
Keep in mind :
1. Take ragular backup
2. Daily check database file sizes.
3. Monitor File growth
4. If u use reindex/rebuilding , Import/Export, Bulk insert, Restore full database
...
January 1, 2009 at 10:35 pm
iqtedar (1/1/2009)
January 1, 2009 at 10:28 pm
WayneS (1/1/2009)
7am / 7pm - full database backup
7:15am - 6:45pm - differential backup every 15 minutes.
Just prior...
January 1, 2009 at 6:53 am
raj acharya (1/1/2009)
paresh i got that problem solution we can get procedure name through error_procedure()
now i want to make database trigger if you have any idea than please pm me...
January 1, 2009 at 5:04 am
sunny Brook (12/31/2008)
IN SQL 2005 Enterprise Edition.
U can not restore database bec database is an use by snapshot.
January 1, 2009 at 3:42 am
Nicholas Cain (12/31/2008)
ftpuser:
pwd:
lcd
put
bye
Check out http://www.nsftools.com/tips/MSFTP.htm for all the commands.
By put or mput command i can transfer only files not folders...
January 1, 2009 at 12:27 am
Viewing 15 posts - 91 through 105 (of 242 total)