Viewing 15 posts - 29,761 through 29,775 (of 39,769 total)
I don't think you have any space savings.
On the multiple sizes, there are places that store 1 or maybe 2 and then resize on the fly. Web servers are...
January 22, 2008 at 9:26 am
What was the reason the database was suspect?
You could try attaching the mdf with no ldf and see if can rebuild it.
January 22, 2008 at 9:23 am
Logins will be in master, and you need to know how to restore this. Jobs in msdb, make sure you know how to recover this.
you might have IP/windows server name...
January 22, 2008 at 9:21 am
There are lots of scripts in the scripts section of this site to do this. Put this in a stored procedure and call that from the job.
January 22, 2008 at 9:20 am
Call microsoft PSS. There aren't good tools for the DBA to fix this and you don't want to mess with your data.
You can try rebuilding the clustered index, but if...
January 22, 2008 at 9:19 am
Yes and no
Model is used for all databases, including tempdb.
you can expand tempdb and it will start there on the next instance restart.
January 22, 2008 at 9:19 am
Very interesting and I wish I had an answer. This almost seems like the RESEED is scanning the huge table which has been marked for truncated, but not truncated.
Sounds like...
January 22, 2008 at 9:17 am
Get a SQL Server 2005 book and read through it. It's ordered, logical, and gives you a framework.
If you're managing servers, get backups/restores down. These are important. I'd agree Security...
January 22, 2008 at 9:15 am
I suppose you could export the data from the msdb tables (sysdbmaintplans), but the problem is these plans have so much stuff connected to your server. They're not as generic...
January 22, 2008 at 9:09 am
Is he mapped to DBO or does he have dbadmin rights?
The tables are still likely created under his name if the former. You can use sp_changeobjectowner to fix this.
January 22, 2008 at 9:03 am
How are you showing the differences? Are these text files or richer (RTF/Word)?
That might impact how to store the data.
January 22, 2008 at 9:02 am
Sorry, my fault. David sent it and I must have forgotten to attach it.
It's there now.
January 22, 2008 at 9:00 am
Why put it in either one? It will cause you issues during recovery (DR) if you need it. I've often seen people forget that these procedures are there, they recover...
January 22, 2008 at 8:59 am
There's no good way to find data other than selecting from every column and table. There are no functions to "search" a database.
If you have some idea of the field,...
January 22, 2008 at 8:58 am
Viewing 15 posts - 29,761 through 29,775 (of 39,769 total)