Viewing 15 posts - 16 through 30 (of 815 total)
This article
http://jmkehayias.blogspot.in/2008/12/estimating-size-of-your-database.html
will answer your question.
December 19, 2012 at 7:20 am
I don't have enough space on local drive.
better to make space or add separate lun for backups. These days buying storage is not at all costly.
December 19, 2012 at 6:51 am
DBCC results for 'BC_ShiftSummaryInfo'.
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row...
December 18, 2012 at 10:41 pm
My backup script runs 2 min if I save the file on C drive.
If I run it to save on "\\ networkmachine\bak" it is extremely slow. 10% per 30 min.
Dont...
December 18, 2012 at 10:31 pm
not sure it "script with data"option is in sql 2005 or not but you can just copy the backup and restore on any 2008 server. Script it out and the...
December 18, 2012 at 5:48 am
just script it out and select the option with data and all required dependency you want.
Its advisable to generate the script per object.
Also, better have two different script folder
1)...
December 18, 2012 at 4:07 am
just modify the initial space and auto-growth option.
If you right click on your database and select properties, then go to files. You will see the initial size details of your...
December 18, 2012 at 2:23 am
We have a table which contains allmost 1 lak to 2 lak of records
querring on that table getting delayed give me idea how to make it faster
Time has...
December 17, 2012 at 4:05 am
How about after initial configuration of your excel with all data, from next time onwards first transfer the required data to temp table and then transfer from this temp to...
December 17, 2012 at 3:08 am
dont you think DR plan is also part of business continuity? Which business will plan DR without considering business continuity 😀
December 13, 2012 at 9:19 pm
No option. You can't do it. Physically it will take time to read the backup file and rewrite the disk. If you haven't pre-built the log file, that has to...
December 10, 2012 at 9:18 am
I have a question on one of the DR scenario,
Lets say I have 14 TB database in oltp mode with no/least performance problem. (yes weired but lets accept it). Now...
December 10, 2012 at 8:22 am
Very nice article. I have started using this in my backup after reading it 4-5 month back in some other forum.
Also, I have configured another job to verify the backup....
September 25, 2012 at 1:47 am
ok, thats really surprising as getting two contradictory answer.
You said telnet is failing but network team says the port is open.
the syntax for telnet is :-
telnet ip port
for ex
telnet...
August 23, 2012 at 4:26 am
the port which you configured for your sql instance.
by default its 1433.
Check the configuration manager to know the port number of your sql instance.
August 23, 2012 at 3:55 am
Viewing 15 posts - 16 through 30 (of 815 total)