Viewing 15 posts - 826 through 840 (of 2,897 total)
.mdf & .ldf file backups aren't of much use if SQL is active. Are you taking proper SQL database backups regularly ? "BACKUP DATABASE MyDatabase ..."
September 13, 2011 at 4:23 am
GilaMonster (9/12/2011)
Note that the restriction on the log file is actually not a restriction. It's 2048 TB, the maximum allowable size for a log file ever.
oops ... good catch
So, if...
September 12, 2011 at 2:57 pm
Are any of your data files set to "restricted" like your log file is ?
September 12, 2011 at 2:27 pm
Krasavita (9/12/2011)
1.FileGrowth in Megabytes from 500 to 1024 primary
(2.FileGrowth in Megabytes from 100 to 500 filegroup=datafile2
3.FileGrowth in Megabytes from 100 to 500 (enable autogroth is checked)filegroup=docs
4.FileGrowth...
September 12, 2011 at 1:40 pm
You can use this to find big tables, but not sure what it has to do with your current problem.
SELECT substring(o.name,1,50) as 'Table Name',
ddps.row_count , used_page_count--, *
FROM sys.indexes AS...
September 12, 2011 at 1:18 pm
You could take a full backup once a week, and a differential daily, and then possibly transaction logs, depending on activity and the importance of the dev data.
September 10, 2011 at 7:49 pm
Ivan, "Archive" is a simple word with many possible complexities.
it might help if you could explain your goals. What is the current environment ? What do the users need...
September 9, 2011 at 12:09 pm
If it is a copy of production on a dev server, you will not "break" anything by stopping backups. Stopping backups means you cannot recover it if you need to,...
September 9, 2011 at 9:15 am
I liked Idera's tool at my previous job, but now use Redgate backup which is ok too.
Most tools offer a free trial so you can try them out.
September 8, 2011 at 2:57 pm
Is there a "rule of thumb" estimate of a reasonable tempdb database size in comparison the the databases on the server ? I know that the processes being...
September 7, 2011 at 12:57 pm
amitchaudhury (8/23/2011)
how can use to find records after a certain date/time if knew the column name...Thanks
Can you be more specific about the details of what you want to do ??
August 23, 2011 at 8:42 pm
Then you could embed the select statement in Excel and run that instead of the sp.
It's been a while, but I think there's some Excel add-in you need.
August 23, 2011 at 10:31 am
I don't think there's anything necessarily wrong with self blocking.
August 23, 2011 at 8:56 am
You could write a stored procedure, then have Excel run the sp to load the data, or export from SQL into Excel.
August 23, 2011 at 8:54 am
Viewing 15 posts - 826 through 840 (of 2,897 total)