Viewing 15 posts - 15,226 through 15,240 (of 49,552 total)
muthyala_51 (12/14/2012)
When compared to yesterday's both the files are of same size(149 GB).
So, despite you asking several times why the files are growing simultaneously, they're actually not growing?
I added space...
December 15, 2012 at 12:57 am
muthyala_51 (12/14/2012)
As far as I know backup log truncates the log and we can reuse it.
Correct. Truncation meaning 'mark 0 or more portions of the log reusable', it does...
December 14, 2012 at 7:41 am
Hemant.R (12/14/2012)
DBCC shrinkfile(file_id ,size) to shrink file
I would certainly hope shrink isn't a 'most frequently used command', as one should not shrink database files without good reason.
DBCC Inputbuffer can be...
December 14, 2012 at 5:45 am
Jason-299789 (12/14/2012)
SQL server doesnt automatically create indexes, except in certain cicumstances such as when you define Primary Key, Foreign Key and Unique Key's.
Primary key and unique constraint only. Creating a...
December 14, 2012 at 3:09 am
sanket kokane (12/13/2012)
GilaMonster (12/13/2012)
saranya.priyadharshini (12/13/2012)
How i Can recover Free space?? Highly Suggest me!!
DBCC ShrinkFile. There's no other way (other than copying the data to a new DB and dropping the...
December 14, 2012 at 3:09 am
Probably be faster to drop the database and recreate it.
This will generate the drop statements for all tables and procedures, you can copy the output to a new window and...
December 13, 2012 at 11:29 pm
saranya.priyadharshini (12/13/2012)
How i Can recover Free space?? Highly Suggest me!!
DBCC ShrinkFile. There's no other way (other than copying the data to a new DB and dropping the old one)
Let me...
December 13, 2012 at 11:28 pm
Not possible. Filegroups can't be restored to a different DB to the one they were backed up from.
SSIS. Bulk insert. bpc.
December 13, 2012 at 3:43 pm
tanvishriya (12/13/2012)
Tried it as well.CREATE TABLE T1
(
CreateDate DateTime2 not null
)
GO
INSERT INTO T1 (createdate)
VALUES ('2012-03-09 12:34:45:567')
GO
throws an error: cannot convert datetime to string
Sure there's no other code anywhere? Nothing else in...
December 13, 2012 at 2:46 pm
GSquared (12/13/2012)
The Dixie Flatline (12/13/2012)
Budget cuts are the reason the first Death Star didn't have a grate or something covering the exhaust port.
Really? I always just assumed a Jawa...
December 13, 2012 at 2:32 pm
Michael Fried (12/13/2012)
December 13, 2012 at 2:30 pm
Not corruption.
When the logins were created on the QA server they were not created with the same SID as the production server. Hence when the backup is restored, the SID...
December 13, 2012 at 12:18 pm
Let me put it this way:
A differential backup contains all the changes since the last full backup. It has no reference, checks, no knowledge of what changed since a previous...
December 13, 2012 at 12:15 pm
Viewing 15 posts - 15,226 through 15,240 (of 49,552 total)