Viewing 15 posts - 7,231 through 7,245 (of 9,253 total)
paulnamroud (3/28/2011)
March 28, 2011 at 12:32 pm
SQL Guy 1 (3/28/2011)
That's amazing! Thanks a lot, Perry. Actually I can use it not only for backups or restores, but for anything else.
You're welcome
March 28, 2011 at 12:27 pm
This should help
selectst.text,
command,
db_name(database_id),
start_time,
DATEADD(ms,estimated_completion_time,
...
March 28, 2011 at 12:02 pm
Abrar Ahmad_ (3/22/2011)
1. Is there any performance benefit of segregating database files on different logical drives (physically single storage medium)?
The only gain here is for administration purposes, no performance...
March 24, 2011 at 9:21 am
Hi UMG
It's to large to post as an attachment I can email to people as requested
March 23, 2011 at 3:52 am
what "other boxes" are you referring too
March 18, 2011 at 4:26 am
suri.yalamanchili (3/17/2011)
I am running three VM's in all on my laptop.
You should have 4 VMs
NAS VM
Domain Controller VM
2 x Cluster nodes
suri.yalamanchili (3/17/2011)
March 17, 2011 at 1:17 pm
I would use
Full backups .BAK
Diff backups .DIF
Log backups .TRN
March 16, 2011 at 4:41 pm
odeonkreel (3/14/2011)
I have no need or desire to retain anything in db2 when I restore db1 into db2.
so, as already stated when restoring DB1 over DB2 use the REPLACE option...
March 16, 2011 at 4:38 pm
jpSQLDude (3/15/2011)
March 16, 2011 at 4:31 pm
Alexander G. (3/14/2011)
Are you sure? I have 2 VMs (each 8 GB RAM) running on one physical machine, but each VM has just one db instance.
how much memory does the...
March 16, 2011 at 4:14 pm
suri.yalamanchili (3/15/2011)
I followed the exact same steps as in your document and I am getting the following error where I install FreeNAS .When I ping Host from the VM....
March 16, 2011 at 4:04 pm
TST1 (3/15/2011)
Thanks for the info, Henrico do you have any articles of how I could implement the physical/vm side? I know I will need to present the VM as...
March 16, 2011 at 4:01 pm
Sql Smith (3/13/2011)
Old Hand is correct. This is a native SQL backup.
Ok can see that now. Is there any particular reason why you included NOUNLOAD, you're not restoring from...
March 14, 2011 at 12:13 am
DTC or quorum 512MB, or 1GB max. Requires no more than this
March 13, 2011 at 9:03 am
Viewing 15 posts - 7,231 through 7,245 (of 9,253 total)