Viewing 15 posts - 16 through 30 (of 37 total)
Dies existing data gets modified?if no,you may consider moving static data to seperate file groups and take backup of those once every 1 or 2 weeks. Can you run report...
January 5, 2010 at 4:04 am
Hi,
1. Use DOS command to list all files in a given location.
2. Execute that through SQL and store results in a table with a time stamp.
You'll see backup file growth...
January 5, 2010 at 3:55 am
Can you tell us what part ofthe database is growing?log or data file?if log,than you might have uncommited transactions.do you make a use of cursors?
December 31, 2009 at 1:21 pm
In terms of modifications, you'll need to keep the track of the following:
1. Previous version of the report
2. Date when the change has occured
3. Person who made the change
4. Link...
December 31, 2009 at 6:58 am
You already know (said) what you need to document. Sounds like you need the standard to follow. Come up with a structured documentation, give it to your work collegues to...
December 31, 2009 at 6:55 am
Just to add...
Ideally, you would want to store the list of all instances/databases in a centralised place. Once you have this sort of documentation in place, many of the maintenance...
December 31, 2009 at 6:52 am
Command prompt:
isql -L
Store that in SQL column. Google for ISQL, OSQL to find out more options.
December 31, 2009 at 6:49 am
Simple recovery model implies that you are not taking the backup of the log file. If log file growth is set to some %, for example 10%, it means that...
December 31, 2009 at 4:51 am
The only thing that I can add, is that you shouldn't really be writing code around something that's already wrong. Rename the file and follow the same naming convention all...
December 31, 2009 at 4:33 am
Ignore the post, it seems to work only within Select.
December 31, 2009 at 4:21 am
Did you try using the escape character so that it treats space as a space???
December 31, 2009 at 4:12 am
How are you trying to access it???
December 31, 2009 at 2:48 am
What the guys said above is correct.
You said that the existing applications fail, that's probably because somewhere you have a stored procedure or SQL in the application which reads...
December 31, 2009 at 2:46 am
When I develop I usually have deployment document where I list the order of the scripts that I need to run. Alternatively I establish the order of the scripts, stick...
December 31, 2009 at 2:41 am
Viewing 15 posts - 16 through 30 (of 37 total)